|
Comments
|
Philip Hickey on
10/14/2009
Excellent video
|
|
|
Useful tool explained with clear example.
|
|
|
blow my mind
|
|
|
very nice one and simple explanation!
|
|
Joshua Clausen on
10/20/2009
quick, concise, and covers just enough contextual information to provide a very good overview
|
|
|
This is a topic I really need to learn more about. It seems to be relatively new to MSSQL, and this video has definitely been an informative beginning for me. It would also be helpful to understand how performance was improved when querying an non-indexed field. Also, more thorough coverage on this topic would certainly be helpful...thanks again!
|
|
|
Can't see properly video, not matter of quality but was so slow cutting the whole movie. Must be low size i believe and please have downloadable version so the user can see video.
|
|
|
Can't see properly video, not matter of quality but was so slow cutting the whole movie. Must be low size i believe and please have downloadable version so the user can see video.
|
|
|
Can't see properly video, not matter of quality but was so slow cutting the whole movie. Must be low size i believe and please have downloadable version so the user can see video.
|
|
|
Can't see properly video, not matter of quality but was so slow cutting the whole movie. Must be low size i believe and please have downloadable version so the user can see video.
|
|
Clayton Smith on
10/21/2009
Lats time I looked into indexed views there were some pretty serious limitations the design of the view in order for it to qualify for indexing. Is it possible to you to add some of these limitations?
|
|
|
Great presentation style. Excellent content. Thanks
|
|
|
New knowledge gain
|
|
Robert McEuen on
10/21/2009
It would be helpful to illustrate what scenarios are clearly best to use these in.
|
|
David Ratliff on
10/21/2009
Very useful. I have a couple of views that are real dogs that I may try this on.
|
|
Kasey Wheeler on
10/21/2009
Good video.
|
|
Steve Ingham on
10/21/2009
General guidelines of when to use it to guide developers who are NOT DBAs.
|
|
|
Using indexed views is always of interest to me. SchemaBinding and noexpand were two important "Heads-Ups"
Thanks Brian,
--John deCoville (keep the cool stuff coming)
|
|
Koray Ozturk on
10/21/2009
Great video and cool tips!
|
|
|
Very good video, easy to understand and use immediately. Thanks
|
|
|
The difference between all execution plans with the last one is plain astonishing. Great work and thank you.
|
|
|
good grief if endusers find out views can be indexed it's all over LOL
|
|
|
The voice is too low
|
|
|
Was hoping for more depth, but was an okay intro.
|
|
|
I seem to recall that there are a number of settings that had to be preset prior to the creation the index was allowed. Are these not required?
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET NUMERIC_ROUNDABORT OFF
|
|
|
Ron, there are quite a few caveats including those you mention. The goal was to outline the technique, not try to include everything in order to stay within the alloted time. We may do a follow up to focus on the gotchas.
|
|
|
waaaaa... awesome !!!!
|
|
Marc Moshman on
3/17/2010
very nice, all new to me
|
|
|
suberb
|
|
|
Thanks.
|
|
|
nice
|
|
|
good stuff
|
|
|
Hi Andy! Gr8 video clear and concise.
|