-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
DBCC CHECKDB requires some amount of temporary space, to find the amount of space required in advance using ESTIMATEONLY option… 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
Examples of using wildcards in LIKE select * from test; x ——– abc cba dba cab e_ab (5 row(s) affected)… READ MORE
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
In SQL Server 2005 using the SQL below one can make the database read-only/read-write. — set database to read only… READ MORE
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
In SQLServer 2005 one can connect to the SQL Server with a special connection called “Dedicated Administrator Connection” called as… READ MORE
sys.configurations – It has server side configuration value name – Name of configuration name value – current value of the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 