Featured
The Latest
-
Database user mode
In SQLServer 2005 one can change the user mode of a database to multi, single or restricted. MULTI_USER – This… READ MORE
-
How to find sessions that are blocked?
To find sessions that are blocking a session and blocked session, one can run the following SQL which works on… READ MORE
-
How to determine proper SQL Server configuration settings?
http://support.microsoft.com/kb/319942 READ MORE
-
Start/Stop SQL Server service through command line
To start SQL Server services (default instance) c:> net start mssqlserver Output: The SQL Server (MSSQLSERVER) service is starting. The… READ MORE
-
master.sys.dm_exec_connections
master.sys.dm_exec_connections – has server-level information about the connections to SQL Server. http://msdn.microsoft.com/en-us/library/ms181509(SQL.90).aspx – SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms181509.aspx – SQL Server… READ MORE
-
|
AIX commands you should not leave home without
http://www.ibm.com/developerworks/aix/library/au-dutta_cmds.html Here are some of the commands How many processors does my system have? To display the number of processors… READ MORE
-
ORADEBUG – UNDOCUMENTED ORACLE UTILITY
Link to oradebug – debug utility http://www.evdbt.com/Oradebug_Modrakovic.pdf READ MORE
-
Examples of using wildcards in LIKE
Examples of using wildcards in LIKE select * from test; x ——– abc cba dba cab e_ab (5 row(s) affected)… READ MORE
-
How to compare data in 2 tables in Oracle and SQLServer?
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
-
How to set database read only/read write?
In SQL Server 2005 using the SQL below one can make the database read-only/read-write. — set database to read only… READ MORE
-
Retreiving metadata
sp_help Display all objects, the owner of the object and object type sp_help object ‘[store procedure name|table name|view name]’ Displays… READ MORE
-
Dedicated connection
In SQLServer 2005 one can connect to the SQL Server with a special connection called “Dedicated Administrator Connection” called as… READ MORE
-
Information on sys.configurations
sys.configurations – It has server side configuration value name – Name of configuration name value – current value of the… READ MORE
-
|
How to enable/disable a job scheduled in SQLServer Agent?
http://blog.flimatech.com/?p=1291 READ MORE
-
|
DBA_TAB_MODIFICATIONS
DBA_TAB_MODIFICATIONS view contains tables that were modified since last time statistics was gathered on the table. It contains the number… READ MORE
-
|
SET STATISTICS
SET STATISTICS TIME [ON|OFF] – Tells how much CPU time and time taken to parse and compile and also the… READ MORE
-
Truncate statement in SQLSever
In SQLServer TRUNCATE TABLE can be rolled back when within a transaction. TRUNCATE still doesn’t log each row when it’s… READ MORE
-
|
How to see job owner, Email operator, Event Notification, Email Notification on jobs scheduled?
Using the SELECT statement below one can list notications that occur for jobs scheduled on SQLServer. SELECT –Job name sj.name… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
