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

Modify columns' name in batches

Modify columns' name in batches.