-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
Link to oradebug – debug utility http://www.evdbt.com/Oradebug_Modrakovic.pdf 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
“Control what I can control”
~ Alex Lima
Alex Lima 