-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1)… READ MORE
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 requires some amount of temporary space, to find the amount of space required in advance using ESTIMATEONLY option… READ MORE
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
To change database to archivelog or noarchivelog mode the database has to be in mount stage. If one tries to… READ MORE
In 8i and 9i archiver process doesn’t automatically startup when database is archive log mode so using the SQL below… READ MORE
Note: Along with user mode the following termination option can be specified ROLLBACK AFTER integer, ROLLBACK IMMEDIATE, NO_WAIT when changing… READ MORE
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
In SQLServer 2005 one can change the user mode of a database to multi, single or restricted. MULTI_USER – This… READ MORE
To find sessions that are blocking a session and blocked session, one can run the following SQL which works on… READ MORE
http://support.microsoft.com/kb/319942 READ MORE
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 – 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
|
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
“Control what I can control”
~ Alex Lima
Alex Lima 