DB File Extension

Kill Database sessions

This script will kill the user sessions on a specified database.

Moving TempDB

One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.

The Ultimate Table Searcher

Searches for tables who's names contain the search string. Gives Size and Rows information as well.

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.

Get record count for a all databases

This is an addition to Jim Rea's "Get record count for a specific database". I modified it to loop through all databases and provide counts.

Iterating through tables and databases in SQL Server

This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on.

move MDF or LDF files to new location

This stored procedure move the LDF or MDF to a new location.

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.