April 29, 2011 at 1:45 pm
Guys,
I'm new to SQL server and looking for some sample Tsql queries, on which i can perform some tuning. I just want to practice performance tuning. Can any one provide me a link for sample Tsql queries so that i can practice Tuning?
Thanks in advance.
April 29, 2011 at 2:07 pm
You could go through some of the questions asked (and answered) in the SS2K5 Performance forum (http://www.sqlservercentral.com/Forums/Forum360-1.aspx).
Or search for "performance tuning" on this site to find numerous questions. Try to answer the questions before looking at the solutions others posted, compare the performance and try to explain why one is fast/slower than the other.
May 2, 2011 at 6:38 am
Yeah, the best performance tuning questions come up on here, all the time. But you can also look at my blog, Paul White's blog[/url], Gail Shaw's blog, and pick up more stuff.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2011 at 7:06 am
Grant Fritchey (5/2/2011)
Yeah, the best performance tuning questions come up on here, all the time. But you can also look at my blog, Paul White's blog[/url], Gail Shaw's blog, and pick up more stuff.
Be careful reading Paul White's blog though - I know some people who's heads exploded when they tried to grok what he has on there! :w00t:
Also get a copy of anything Grant has in print!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply