THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL Tuesday » xml » puzzle   (RSS)
  • T-SQL Tuesday #002: Is it XML, or Not?!?

    The query optimizer is a finicky thing, and sometimes it doesn't understand exactly what you're trying to do until you give it a bit more information. The situation I'm going to describe in this post is one such case. By providing the optimizer with ever-so-slightly more data, it's possible to make some XML processing over 300 times faster. ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 12, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement