This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.
2012-11-23 (first published: 2012-10-17)
1,326 reads
This script will produce the top 10 wait state issues along with their descriptions.
2012-11-22 (first published: 2012-10-22)
1,778 reads
2012-11-21 (first published: 2012-10-02)
1,594 reads
2012-11-16 (first published: 2012-10-02)
1,219 reads
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,238 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,096 reads
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,948 reads
2012-10-30 (first published: 2012-10-12)
2,334 reads
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,895 reads
2012-10-26 (first published: 2012-10-02)
961 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers