Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Bodhisatya Mookherjee

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Find the size of all Indexes in a database

This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.  Read more...
By Bodhisatya Mookherjee 2013/10/15 | Source: SQLServerCentral.com | Category: indexes
Rating: |  Discuss |   Briefcase | 1,494 reads

Find Top 5 executed queries ordered by execution count

I wrote this query that helps us find executed queries with most number of execution counts. 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.  Read more...
Rating: |  Discuss |   Briefcase | 1,895 reads

Find Top 5 expensive Queries from a Write IO perspective

Top 5 expensive Queries from a Write IO perspective  Read more...
By Bodhisatya Mookherjee 2013/10/03 | Source: SQLServerCentral.com | Category: dmvs
Rating: |  Discuss |   Briefcase | 1,790 reads

Find Top 5 expensive Queries from a Read IO perspective

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.  Read more...
By Bodhisatya Mookherjee 2013/09/27 | Source: SQLServerCentral.com | Category: dmvs
Rating: |  Discuss |   Briefcase | 1,937 reads

Primary Keys which are not Clustered Indexes in a database

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.  Read more...
By Bodhisatya Mookherjee 2013/09/18 | Source: SQLServerCentral.com | Category: primary keys
Rating: |  Discuss |   Briefcase | 1,824 reads

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database  Read more...
By Bodhisatya Mookherjee 2013/09/11 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,339 reads
   Items 1 to 6 of 6