Scripts by Wilfred van Dijk

This function returns all the necessary version information in a table.  Read more...

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'  Read more...

This view reports almost everything you want to know about your indexes  Read more...

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...

This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.  Read more...

This procedure searches for your criteria not only in code, but also in objectnames  Read more...

This procedure drops all manually added statistics (field user_created=1)  Read more...

Which jobs are ready to run the next 24 hours / this weekend?  Read more...

shows index usage.   Read more...

This procedure disables or rebuilds indexes for a given tablename  Read more...

function which checks a database on availability  Read more...

displays a graphical tree of dependencies of an object  Read more...

Stored procedure which creates snapshot of database. Timestamp in snapshot. Multiple datafiles are supported  Read more...

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...

Better script for determining unused indexes  Read more...

Shows unused indexes compared to nr of modifications  Read more...