|
Comments
|
|
A good simple tip that I wish I'd seen 2 weeks ago.
thanks
W
|
|
|
I prefer the video to be in flv format like youtube. while watching the video it gets downloaded to my PC as well. The following are the uses for that:
*) When i dont understand something, i can go back and replay the last 30 secs without redownloading that part.
*) on a slow connection, I let the video download. and replay it later without any delays within the video.
|
|
|
It would have been worth another minute to explain what to do about it when they're out of whack.
|
|
|
Awesome example. Thank you.
|
|
Steve Harris on
12/22/2009
maybe show the SQL command to update statistics
|
|
|
i like rich content like this. keep up with the good work.
|
|
|
i like video with rich content liked this. keep up with the good work.
|
|
Mark Sopczak on
12/24/2009
I had no idea, thanks
|
|
|
excellent!!
it would be great if there were a series on Top 10 issues to look for in an execution plan...just sayin
|
|
|
This is mostly a moot point if auto-update stats is on, and for most databases it should be..If not, create a policy to make sure it is on for all of your databases in case you forget.
|
|
Carla Wilson on
12/30/2009
I would have liked to see how the execution plan changes when the statistics are updated, and the optimizer decides to use a better technique.
|
|
|
Narrator said "3rd row down ... says Estimated Number of Rows" when hovering over query plan, but actually meant to say "3rd row down ... says Actual Number of Rows."
|
|
|
Excellent tip
|
|
|
nice one
|
|
|
Good video worth watching...
|