SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...

UPDATE

@@DBTS

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.

T-SQL Parsing Crazy Eights

The Dynamic Tally or Numbers Table

Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.

newid() and newsequentialid()

T-SQL Fun

DDL or DML

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005