The system page file should not be on the same physical spindle as any database files, otherwise you will not get optimum performance from the drive as its disk head will be jumping between the page file and the database files. Ditto for placement of...

I have seen where DBAs would right click the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step - similar to what you see below: DTSRun...

There is windows “SC” utility and the following “Heart Beat” approach. http://www.databasejournal.com/features/mssql/print.php/3347241 You can use SC query and look for string RUNNING SC \\machineName query MSSQLSERVER ! findstr “RUNNING...

You can use INFORMATION_SCHEMA.VIEW_TABLE_USAGE and INFORMATION_SCHEMA.VIEW_COLUMN_USAGE from SQL70 onwards. And you can use sys.sql_dependencies in SQL Server 2005.

I found one of my old documents where I kind of summarized Indexes on a SQL Table, might help. Indexing SQL Table Primary Key: · Creates clustered index on the column · Doesn't allow NULLS Unique Key: · Creates non-clustered...