Importance of UPSERT

A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.

Identify Unique Columns

Tool to automatically query combinations of columns in your table to determine candidate for unique key.

Identify Large Tables

Reports on physical size of tables in your database to identify largest.

sp_validname

Session Context Information

sp_helpdb

Evaluating How Filtering Options Affect T-SQL Performance

The many popular rules concerning T-SQL filtering operators can't be trusted implicitly; instead, you should evaluate your options explicitly.

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.

Trim Trailing Blanks in SQL Queries

Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.

Updating a View