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 20 of 20   
 

All OS version info in one function

Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)  Read more...
By Wilfred van Dijk 2014/12/06 | Source: SQLServerCentral.com | Category: os
Rating: |  Discuss |   Briefcase | 145 reads

move tempdb

For maximum performance, tempdb should be placed on a seperate disk. This script does all the work for you, except the restart!  Read more...
By Wilfred van Dijk 2014/10/13 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,070 reads

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.  Read more...
By Wilfred van Dijk 2014/07/31 | Source: SQLServerCentral.com | Category: sqlagent
Rating: |  Discuss |   Briefcase | 1,293 reads

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,128 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,063 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,356 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,765 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 | 2,011 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 | 447 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,055 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 | 574 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 | 409 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,144 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,382 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 | 805 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 | 258 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 | 761 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 | 922 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,973 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,628 reads
   Items 1 to 20 of 20