Featured
The Latest
-
How to move tempdb database files and user databases to new location?
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1)… READ MORE
-
SQLServer create as (CTAS)
In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is… READ MORE
-
DBCC CHECKDB – Estimate
DBCC CHECKDB requires some amount of temporary space, to find the amount of space required in advance using ESTIMATEONLY option… READ MORE
-
Global_names and global_name in Oracle
http://arjudba.blogspot.com/2008/05/globalnames-and-globalname-in-oracle.html To view and change global_name 22:53:34 system@TESTPRD> select * FROM global_name; GLOBAL_NAME ——————————————————————————- TESTPRD.WORLD 22:53:43 system@TESTPRD> ALTER DATABASE RENAME… READ MORE
-
Change archivelog/noarchivelog
To change database to archivelog or noarchivelog mode the database has to be in mount stage. If one tries to… READ MORE
-
Check archiver is running on archivelog mode?
In 8i and 9i archiver process doesn’t automatically startup when database is archive log mode so using the SQL below… READ MORE
-
Termination mode
Note: Along with user mode the following termination option can be specified ROLLBACK AFTER integer, ROLLBACK IMMEDIATE, NO_WAIT when changing… READ MORE
-
Script to kill/terminate sessions connected to a specific database
DECLARE @dbName VARCHAR(100) SET @dbName = 'AdventureWorks' DECLARE @sql VARCHAR(50) DECLARE @spid SMALLINT DECLARE @loginame NVARCHAR(256) DECLARE @hostname NVARCHAR(256) DECLARE… READ MORE
-
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
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- 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
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- 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
Alex Lima 