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

Scripts by Wilfred van Dijk

SQLServerCentral.com profile

   Items 1 to 17 of 17   
 

Unique Identifier as Clustered index

This script selects clustered indexes containing only a uniqueidentifier column  Read more...
By Wilfred van Dijk 2013/10/17 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 1,108 reads

All SQL Version info in one function

This function returns all the necessary version information in a table.  Read more...
By Wilfred van Dijk 2012/05/28 | Source: SQLServerCentral.com | Category: version
Rating: |  Discuss |   Briefcase | 3,042 reads

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'  Read more...
By Wilfred van Dijk 2010/05/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,346 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,741 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,994 reads

Wait for Mirror treshold

This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.  Read more...
By Wilfred van Dijk 2009/11/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 445 reads

Search in your T-SQL objects

This procedure searches for your criteria not only in code, but also in objectnames  Read more...
By Wilfred van Dijk 2009/11/16 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,051 reads

Drop user statistics

This procedure drops all manually added statistics (field user_created=1)  Read more...
By Wilfred van Dijk 2009/06/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: (not yet rated) |  Discuss |   Briefcase | 557 reads

Report upcoming SQL Jobs

Which jobs are ready to run the next 24 hours / this weekend?  Read more...
By Wilfred van Dijk 2008/12/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 401 reads

2005 unused indexes v3

shows index usage.   Read more...
By Wilfred van Dijk 2008/09/05 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 1,119 reads

disable/enable indexes for table

This procedure disables or rebuilds indexes for a given tablename  Read more...
By Wilfred van Dijk 2008/10/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,377 reads

udf_is_database_available

function which checks a database on availability  Read more...
By Wilfred van Dijk 2008/08/26 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 781 reads

usp_dependencytree

displays a graphical tree of dependencies of an object  Read more...
By Wilfred van Dijk 2008/06/25 | Source: SQLServerCentral.com | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 253 reads

usp_createsnapshot

Stored procedure which creates snapshot of database. Timestamp in snapshot. Multiple datafiles are supported  Read more...
By Wilfred van Dijk 2008/07/04 | Source: SQLServerCentral.com | Category: database snapshots
Rating: (not yet rated) |  Discuss |   Briefcase | 756 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2013/07/09 | Category: t-sql
Rating: |  Discuss |   Briefcase | 920 reads

2005 Unused indexes v2

Better script for determining unused indexes  Read more...
By Wilfred van Dijk 2008/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,962 reads

2005 unused indexes

Shows unused indexes compared to nr of modifications  Read more...
By Wilfred van Dijk 2007/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,619 reads
   Items 1 to 17 of 17