Two easy ways to improve SP performance without changing T-SQL: do not prefix stored procedures with sp_, and call them by the fully qualified dbo name.
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.
SQL SERVER – Performance Optimization of SQL Query and FileGroups
My tips on transaction log placement, FileGroups for tables and non-clustered indexes, database size and autogrow settings for better SQL Server performance.
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.
SQL SERVER – 2005 – Performance Dashboard Reports
SQL Server 2005 Performance Dashboard Reports show CPU, IO, blocking and missing index problems as they happen. How to set them up and read them well.
SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)
What the SQL Server 2005 Best Practices Analyzer did, how to act on its report, and why checking your servers on a regular schedule still matters.
SQL SERVER – Index Seek Vs. Index Scan (Table Scan)
Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table.