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

Generate INSERT for table with IDENTITY column

Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.

TOP Updates

View Column Resolving Issue in Sub-Query

Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.

Don't forget the Title

When using the output for generated code don't forget the title

Truncate Locks