This script will show you all open transactions from any query windows.  Read more...

Changes the database compatibility level of all databases to the given level.  Read more...

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes  Read more...

This Powershell script calls a stored procedure and exports the results to a CSV file  Read more...

T-SQL that allows you to import tab delimited text file into correct table based on file name.  Read more...

Number of workings days in a month minus weekends and holidays.  Read more...

Script to get #rows in each table  Read more...

Simple script which create a list of all the tables and rows of the selected DB.  Read more...

Generates "check this foreign key" statements for all not-trusted foreign keys on a server.  Read more...

This function will return a value of date if found within a string, the date format in the string will vary. If no date is found a null value is returned  Read more...

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...

Get database status,file details,free space in sql 2005 and 2008 sql versions  Read more...

This Script can be used to pick out a temporary table from tempDB you might want to Check and drop the table before you create it just in case , but I Haven't included it here  Read more...

The query tells whether sql server enterprise edition is using any enterprise level features or not   Read more...

The below query finds out actual number of physical cpu installed on the server   Read more...

In a given input string, The script searches for 5 consecutive digits and replaces it with a special character.   Read more...

You can use the following query to find the currently active requests, their associated T-SQL statement, and the corresponding query plan that is allocating most space resources in tempdb.  Read more...

Using sys.dm_os_buffer_descriptors we can find out how much memory a database or a object is consuming.  Read more...

Convert Horizontal Hierarchy to vertical Hierarchy.  Read more...

History table needs individual rows for each column that has been updated, i.e., a column history.  Read more...