Browse by Tags

• #tsql2sday
• code generator
• dense_rank
• extended events
• Performance
• puzzle
• T-SQL Tuesday

• 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 Read More... Posted Tuesday, January 12, 2010 5:19 PM by Adam Machanic | 9 Comments Filed under: puzzle, xml, T-SQL Tuesday, #tsql2sday

• Uniquely Identifying XML Nodes with DENSE_RANK

  When 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 Read More... Posted Monday, August 03, 2009 9:43 AM by Adam Machanic | 8 Comments Filed under: xml, dense_rank

• Introducing: Extended Events Code Generator v1.0

  SQL 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 Read More... Posted Thursday, July 30, 2009 4:16 PM by Adam Machanic | 5 Comments Filed under: Performance, extended events, xml, code generator Attachment(s): xe_code_generator_v1_000.zip