SQL Server: What I Have Learned In March 2011

Dedicated to Grant Fritchey, a Leader of SQL Server community.

TSQ Tips & Tricks

• SQL Server: TSQL Script to Get Hard Drives Detail
• SQL Server: Querying Case Insensitive Data with Case Sensitive Filters
• SQL Server: Cascade Delete
• SQL Server: The Magical OVER clause
• SQL Server: How to Get Strings Which Contains Special Characters
• SQL Server: How to Load Files From Given Directory To a Table

Performance Tuning

• SQL Server: Small Tables’ Clustered Indexes Fragmentation
• SQL Server: How to Analyze Blocking and Deadlocking

SQL Server Basic Concepts

• SQL Server: Understanding Output of SET STATISTICS TIME ON
• SQL Server: Execution Plan Major Points in Query Optimization
• SQL Server: Difference between Locking, Blocking and Dead Locking
• SQL Server: What is an Algebrizer ?

SQL Server Community

• SQL Server: Great Opportunity to Learn Indexes
• SQL Server: A Brief Introduction to SQL Server Denali
• SQL Quiz: Solve Simple TSQL Quiz and Win an Apple iPad

SQL Server Hardware Health

• SQL Server: Is Your Database Server's Hard Drive Working Properly?

SQL Tools

• SQL Server: How to Find Costliest Nodes in Graphical Execution Plan
• SQL Server: Multiple Objects Script but Save Each to Separate Files

SQL Server Management

• SQL Server: How to Avoid Big Single Error Log File on Production Servers