An alternative solution to passing parameters to sp_executesql.  Read more...

Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.  Read more...

If you ever need to find out what database is using up the most buffer pool resource, this will help. You will also get the object in the buffer for the specific database that is using up the most buffer resource. It will help when troubleshooting buffer related issues.  Read more...

I have a brief note in the query header itself  Read more...

Here an easy way to setup alerts for all sql agent jobs. Typically I use this to send an email alert when a job fails. I always setup a group email address rather than individuals to make this a one-time setup.  Read more...

Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.  Read more...

Here is a short code to count the VLFs in the transaction log for each database in the instance.  Read more...

Return a list of databases which contain a table from wildcard table name.  Read more...

Size of database files for an instance of SQL Server  Read more...

Generated script to update statistics  Read more...

Generate script to reorganize indexes in a database  Read more...

Extracting data with header information using PowerShell  Read more...

We use a tally table to find the appropriate denominator for a given decimal part of a number.   Read more...

Backup all databases for an instance (complete, Differential or log of transactions)   Read more...

Count all the records from the tables that exist in a database  Read more...

Lists Tables and Store Procedure references. Runs a bit slow but appears to be accurate.  Read more...

usefull script for moving databases from one server to another  Read more...

THis script will generate the Drop and create script for all user define table type  Read more...

Generate and execute dynamically select statement for unpivot table  Read more...

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...