Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.
2013-10-02 (first published: 2008-08-01)
3,713 reads
The below written query helps us find the most expensive queries from a read IO perspective. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2013-09-27 (first published: 2013-09-09)
2,633 reads
This script is a universal foreach stored procedure. You can loop through everything with the help of if.
2013-09-24 (first published: 2013-09-10)
1,820 reads
Displays the information of the date of the latest backup that was done back to @daysago. When value is -0 it gives you all the backup information. The script also gives information on databases that never have been backed up.
2013-09-20 (first published: 2013-08-30)
1,588 reads
Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.
2013-09-18 (first published: 2013-09-04)
1,928 reads
2013-09-17 (first published: 2013-02-08)
669 reads
2013-09-17 (first published: 2013-09-06)
1,458 reads
2013-09-12 (first published: 2013-02-08)
1,891 reads
Use this script to find all the Foriegn Keys and their details in a database
2013-09-11 (first published: 2013-09-02)
1,428 reads
Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.
2013-09-10 (first published: 2013-08-28)
1,358 reads
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers