|
Comments
|
Juri Kirillov on
11/5/2010
i hope to use it somewhere :)
|
|
|
Thank you so much.
|
|
|
Andy, good video. Please format the code so we can see it in the screen. The create index code was cut off.
Good Stuff...Keep'em coming.
Thanks
|
|
|
Great Demo - Can we get a copy of the sample code?
|
|
|
wonderful video - i would enjoy more tuning-related videos, especially for BI cubes
|
|
Steve Harris on
11/5/2010
Execellent example. Showed not only explain plan but how to use the profiler.
May want to show how to start and capture information in profiler.
|
|
|
very clear and to the point. Great Job!
|
|
|
(1) You did not mention that with computed column but no index on it, there is no choice for SQL Server but to do a clustered index (table) scan. Also, you should emphasize that a clustered index scan *is* a table scan.
(2) You put FirstName into the index. Having an included column is better, because there will be fewer root [and intermediate] index pages. In another lesson, you might talk about indexing -- in a series of videos.
You do a great job on showing how functions behave! Please keep it up.
|
|
Mark Hathaway on
11/8/2010
This was great. I'd love to see more on tuning.
|
|
|
couldn't see the progress windows due to font size
|
|
|
Please, Add Code, thanks
|
|
|
excellent, as always
|
|
|
Excellent Video..great info... Thank you!!!
|
|
|
Today I learnt a new term. Good work
|
|
|
Excellent
|