SQL MVP Grant Fritchey posted his “The Seven Deadly Sins against TSQL Performance” article quite a while ago, but it is still relevant today. If you are new to TSQL, or just want to understand some common things that kill performance. Take a few minutes to check it out.
In the article he covers
- Using the wrong data types
- Using Functions in Comparisons within the ON or WHERE Clause
- Employing Multi-Statement User Defined Functions (UDFs)
- The “Run Faster” Switch: Allowing “Dirty Reads’
- Applying Query Hints indiscriminately
- Allowing “Row By Agonizing Row” processing
- Indulging in Nested Views
Write Fast Code and Meet an MVP
And if you are available next Tuesday (December 13th) one of our local SQL MVPs, Jeff Moden (known for coining the phrase RBAR or Row By Agonizing Row), will be giving his nearly annual presentation on “Nasty Fast Code Techniques”.
You can register here if you want (they just use it to determine how much of which type of pizza / salad to order)
The SQL Server User Group meets at the Microsoft Building in Southfield from 6 to 8pm, normally the second Thursday each month.
Microsoft Southfield Office
1000 Towncenter
Suite 1930
Southfield, MI 48075
Directions found by clicking here.
What techniques seem most helpful to you?
Let us know in the comments below.
