sp_help_job returns information about SQL Server Agent jobs in msdb. Run it with no parameters to list every job, plus a few related Agent posts.
SQL SERVER – Trace Flags – DBCC TRACEON
Trace flags let a DBA turn a database function on or off for a while. How to use DBCC TRACEON and TRACEOFF, with deadlock trace flag 1205 as the example.
SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table
Msg 544, cannot insert explicit value for identity column, happens when IDENTITY_INSERT is OFF. Turn it ON, insert your rows, then turn it OFF again.
SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility
Use sp_dbcmptlevel to change the database compatible level, like 80 for SQL Server 2000 or 90 for 2005, plus the three step best practice to do it.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – SP
A friend emailed me this stored procedure about marriage, and the bride answers with DROP HIM. Pure SQL humor, for fun only, never for a real server.
SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples
TABLESAMPLE returns a random sample of rows by percent or row count. My examples show why the same query returns a different number of rows each time.
SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key
A query on sys.indexes to find every table without clustered index in a database, why heaps can slow you down, and how to pick a clustered key.