One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek and an index scan.
Transact-SQL is easy to learn. But to truly get the best performance from your SQL Server you must have a good understanding beyond the basics of syntax. To become a Transact-SQL Superhero, you must be aware of some of the nuances of the language and how little things can affect your queries.
PASS DBA Virtual Chapter LiveMeeting Event
On Wednesday, 23 February, 2011, at noon Eastern Standard Time, I’ll share some of the lessons I’ve learned during my years of working with SQL Server. We’ll discuss indexing, stored procedures, triggers, and even user-defined functions.
I hope you’ll join me for this free webcast.
- When Were The Statistics In SQL Server Last Updated?
- The PowerShell CookBook
- Life Guarding Your Data
- TechNet WebCast: SQL Server Locking And Blocking
Filed under: Administration, Events, SQLServerPedia Syndication, T-SQL