|
Author:
Author Bio:
Kendal Van Dyke is a Senior DBA with Channel Intelligence in Celebration, Florida. He uses XML extensively in the database at work and believes that the improvements to XML handling in SQL 2005 substantially change how and why we handle XML.
|
|
|
Creating Primary Indexes on XML Data Types in SQL Server
This video show you how to create primary indexes on xml data types in SQL Server 2005 / 2008
|
Video Information
|
Publish Date:
|
October 13, 2008
|
Length:
|
3:17
|
Skill Level:
|
100
|
Rating:
|
4.00 out of 5
|
|
|
|
|
|
You must be logged in to view this video.
|
|
 Stumble
|
|
|
|
Comments:
|
|
Need more demo to show what the benefits are during run time.
|
|
Carla Wilson on 11/4/2008
Discussion of the caveats is a big help.
|
|
|
1. If you had a Powerpoint that listed everything you said about XML index, that would have been great, if not atleast have it as notes in the Query Analyzer window
2. In your SSMS window, please close the "Object Explorer" window, if you are not going to use it, to ensure there is enough real-estate for viewer
3. Increase Font-size in QUERY window please
|
|
|
should spend more time talking about why you'd want/need to do this. imho
|
|
|
|
|
|
|