http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/xml/default.aspxTags: xmlenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/01/12/t-sql-tuesday-002-is-it-xml-or-not.aspxTue, 12 Jan 2010 21:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:20965Adam Machanic8http://www2.sqlblog.com/blogs/adam_machanic/comments/20965.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=20965The 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/01/12/t-sql-tuesday-002-is-it-xml-or-not.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=20965" width="1" height="1">#tsql2sdaypuzzleT-SQL Tuesdayxmlhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspxMon, 03 Aug 2009 12:43:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15704Adam Machanic7http://www2.sqlblog.com/blogs/adam_machanic/comments/15704.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=15704When working with XML in SQL Server, you might want to uniquely identify one node against another. But due to the flexibility with which XML can be defined, this is not always directly possible. SQL Server's own XML structures are guilty of having this...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=15704" width="1" height="1">dense_rankxmlhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/07/30/introducing-extended-events-code-generator-v1-0.aspxThu, 30 Jul 2009 19:16:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15621Adam Machanic5http://www2.sqlblog.com/blogs/adam_machanic/comments/15621.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=15621SQL Server 2008 Extended Events. It's a high-performance, feature-rich, and extremely useful tracing system. Too bad it's so difficult to figure out how to use it ! Or is it? Earlier this week Jonathan Kehayias announced his SSMS addin for Extended Events...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/07/30/introducing-extended-events-code-generator-v1-0.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=15621" width="1" height="1">code generatorextended eventsPerformancexml