SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by David Kranes

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

Index Usage Stats

This script returns index usage stats along with drop and create DDL.  Read more...
By David Kranes 2017/05/16 | Source: SQLServerCentral.com | Category: tuning
Rating: |  Discuss |   Briefcase | 545 reads

Identify tempdb usage

Identifies SQL and or Jobs that are using tempdb space.  Read more...
By David Kranes 2016/10/07 | Source: SQLServerCentral.com | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 904 reads

Get Database info

This SQL script will return basic information on each database on your server.  Read more...
By David Kranes 2014/01/21 | Source: SQLServerCentral.com | Category: database information
Rating: |  Discuss |   Briefcase | 2,174 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2015/02/24 | Source: SQLServerCentral.com | Category: statistics (data)
Rating: |  Discuss |   Briefcase | 1,476 reads

Determine when a Stored Procedure was created and last altered

Determine when a Stored Procedure was created and last altered.  Read more...
By David Kranes 2015/02/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 3,397 reads

Modified SP_WHOM

Provides sp_who data plus a connection summary and lead blocker details.  Read more...
By David Kranes 2015/10/21 | Source: SQLServerCentral.com | Category: sp_whom
Rating: |  Discuss |   Briefcase | 3,760 reads

Generate Trigger DDL

Dynamically generate trigger DDL and write to individual SQL files.  Read more...
By David Kranes 2013/12/02 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 1,643 reads

View Active Session SQL

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...
By David Kranes 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,229 reads
   Items 1 to 8 of 8