Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions

Date: June 14, 2012 from 4:30PM to 5:45PM
Day 4
DBI404
Speakers: Michael Rys
Avg Rating: 0
5,274 Views
4 Comments
reddit

Tweet

1 hour, 17 minutes, 10 seconds

format
< > embed
+ queue

Sign In first to access your queue.
Close

Sorry, video was not added to the queue, an error occurred. Please Contact Us and let us know.
Close

Embed code for this video

Copy the code above to embed our video on your website/blog.

Video format

Option selected may change based on video formats available and browser capability.

Auto
Use our suggested format for this video.
Smooth Streaming
Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required
Progressive
Traditional buffered video format. Silverlight 5 required
HTML5
For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.
Flash
For browsers that have the Adobe Flash Player plugin installed.

Download

Right click “Save as…”

Slides (view online)

MP3 (Audio only)

File size
70.7 MB
Mid Quality WMV (Lo-band, Mobile)

File size
187.6 MB
High Quality MP4 (iPad, PC)

File size
942.6 MB
Mid Quality MP4 (WP7, HTML5)

File size
657.1 MB
MP4 (iPod, Zune HD)
High Quality WMV (PC, Xbox, MCE)

Have you ever written an XQuery against the XML data type and had performance issues? Have you ever wondered how to improve performance of your XML-based application? In this presentation, we analyze commonly encountered query patterns and performance issues and provide best practices and improved queries that can improve performance up to an order of magnitude. We provide guidance on how to best store XML inside the database (relational vs. as XML datatype, with or without a schema, which XML Index should I use?) and provide performance tips when using XQueries and FOR XML queries. In addition, we give a quick preview of a new XML Indexing option that we have been developing for one of our premier banking ISVs which will be productized in a future release. #TEDBI404

Tag:
- Database & Business Intelligence
Level:
- 400 - Expert

Follow the Discussion

Subscribe to these comments

Error

Jun 16, 2012 at 4:13 PM

"The specified blob does not exist."

Could somebody please fix the download link?
Duncanma "yeah that's awful close, but that's not why I'm so hard done by"

Jun 16, 2012 at 5:52 PM

@Error:sorry about that, fixed!
Reiner

Jun 18, 2012 at 4:14 AM

Hi.

I still am getting the same error. Can someone please fix it? :-)

Thanks.
bradleydonmorris

Jun 20, 2012 at 6:53 AM

Is the PowerPoint available for this? The link returning a BlobNotFound error.