T-SQL Tuesday

Invitation to T-SQL Tuesday #17 – APPLY Knowledge

Logo for T-SQL Tuesday

T-SQL Tuesday

Edit: the party is over, but you can check out our contributors here.

Time to get revved up for T-SQL Tuesday the 17th. As a reminder, here’s Adam’s definition of T-SQL Tuesday:

T-SQL Tuesday is the SQL Server blogosphere’s first recurring, revolving blog party. The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to participate is invited to write a post on the chosen topic. The event is called “T-SQL Tuesday,” but any post that is related to both SQL Server and the theme is fair game. So feel free to post about SSIS, SSRS, Java integration, or whatever other technologies you’re working with in conjunction with SQL Server. Even if your post includes no T-SQL, we still want to see it.

APPLY Knowledge

Recently on Twitter, I heard the claim that “If you don’t understand the APPLY operator, your skills are somewhere around the 50th percentile at best.” While I believe that Adam was giving a warning to self-proclaimed experts (possibly one he might have been interviewing at the time…), I also believe that we could take it as a challenge as a T-SQL blogging community to learn more about APPLY and the ways in which we can use it in our work.

Please share how you use this wonderful feature. Maybe you know how APPLY works inside and out? Perhaps you’ve got a fantastic user defined function (UDF) to share? Or maybe your experience revolves around using Dynamic Management Functions (DMFs) in your never-ending quest for SQL Server performance? Let the community know as it is time to study!

Rules of Engagement

  1. Your post must be published between 00:00 GMT Tuesday, April 12, 2011, and 00:00 GMT Wednesday, April 13, 2011.
  2. Your post must begin with the T-SQL Tuesday logo, and it must be linked back to this blog post.
  3. Make sure that you’re represented in the round-up by leaving a comment below with a link back to your post. Trackbacks should work, but I’m not going to work to find your post if they don’t.

Make it a Success!

  1. Reference T-SQL Tuesday in your post’s title!
  2. Tweet about your newly minted post on Twitter using the #tsql2sday hashtag!
  3. Let Adam Machanic know that you want to host T-SQL Tuesday! You have to have paticipated twice and blog regularly to qualify.
Standard