|
|
|
|
|
|
|
|
|
Performance Tuning Quiz #3 - Part 1
As usual in our quizzes Part 1 is devoted to setting up a simple test, you'll need some data from Adventureworks, and then we'll show you a very common scenario - a select COUNT(*) query. Can you make it run faster than 425 reads? How low can you go? If you're really anxious for the answer, we're loading Part 2 today as well, or you can wait until we release the answer on Thursday!
|
|
|
|
Duration:
|
2
mins
18
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.15
out of 5
|
|
Publish Date:
|
May 24, 2010
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
|
Comments
|
|
Good challenge.
|
|
|
video is too slow, stops constantly
|
|
|
Excellent challenge, I could only get down to 20. And I use to be one of those mentioned in the video that added pk from designer lol.
|
|
|
I cannot watch the video
|
|
|
Waiting with bait in my mouth to see part 2.
Thanks for the good quizzes.
|
|
|
Can't seem to find the answer. When I pull up Part 2 - The answer it seems to be Part 1 - The Quiz
|
|
|
Great format! Great challenge.
|
|
|
Code/scripts/database posted for performance tuning quiz #3 is not correct. The scripts for #2 are attached to #3. Please correct the attached scripts.
|
|
|
good one
|
|
|
good stuff
|
Must Be Logged In
|
|
|
|
|