T-SQL Optimization Tips
-
Dear All,If you want to optimize the performance of the T-Sql please follow the link to get the tips about.
http://databaseblogs.blogspot.com/
Pandu Kovur
-
Aye. Thank you for the tips... there have been several discussions over temp tables and table variables and most have involved some form of blood-letting
Here's a URL from Microsoft that talks about the advantages and disadvantages of both as well as clearing up some myths...http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply