Browse by Tags

• #tsql2sday
• challenge
• concatenation
• contest
• grouping
• Performance
• Query Tuning
• T-SQL
• T-SQL Tuesday
• xml

• T-SQL Tuesday #002: The Roundup

  According to T-SQL Tuesday rules as ratified by me in the first and second T-SQL Tuesday posts, the T-SQL Tuesday host is supposed to post a roundup within two days of the end of the event. So a reasonable person should expect a roundup to be posted by Read More... Posted Monday, February 08, 2010 3:14 PM by Adam Machanic | 13 Comments Filed under: puzzle, T-SQL Tuesday, #tsql2sday

• 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

• T-SQL Challenge: Grouped String Concatenation

  It's been quite a while since the LIKE vs ? Puzzle , and I feel like it's time for another one. Response was overwhelming last time, and I'm back with a much tougher puzzle and a much bigger prize. So get ready, because I'm going to really make you stretch Read More... Posted Friday, February 27, 2009 2:22 PM by Adam Machanic | 48 Comments Filed under: T-SQL, puzzle, contest, challenge, grouping, concatenation Attachment(s): grouped_string_concatenation_output.zip

• SQL Server Query Processing Puzzle: LIKE vs ?

  How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [<do_not_mail> @ do_not_mail.com]. Make sure to include an explanation of why it works, as well as your Read More... Posted Tuesday, April 22, 2008 11:18 AM by Adam Machanic | 36 Comments Filed under: Performance, Query Tuning, puzzle