Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,318 reads
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,417 reads
This script will give you a overview of the current database files.
2013-03-21 (first published: 2013-02-27)
1,275 reads
Get list of tables with no identity fields
2013-03-19 (first published: 2013-03-01)
1,072 reads
This script will allow you to get maximum date associated with tables that contain a certain column.
2013-03-18 (first published: 2013-02-22)
1,186 reads
Converts xml value into multi line string with indents
2013-03-15 (first published: 2013-02-21)
7,895 reads
Returns your date in the format mask you require.
2013-03-11 (first published: 2013-02-20)
2,196 reads
Drop indexes no longer being used.
2013-03-08 (first published: 2009-10-02)
3,412 reads
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,093 reads
A simple script that transfers triggers from one database to another.
2013-03-04 (first published: 2013-02-12)
4,061 reads