If you're one of the estimated 3-5 people who've downloaded and are using my XE Code Generator, please note that version 1.000 has a small bug: text data (such as query text) larger than 8000 bytes is truncated. I've fixed this issue and am pleased to present version 1.001, attached to this post. Enjoy, and...

Just a quick note for those of you who may not have seen Michael Coles's post (and a reminder for the rest of you): The topic of this month's T-SQL Tuesday is LOB data. Get your posts ready; next Tuesday we go big!

The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. What's not to love? But use cases for the view are...

Reports. They're supposed to look nice. They're supposed to be a method by which people can get vital information into their heads.And that's obvious, right? So obvious that you're undoubtedly getting ready to close this tab and go find something better to do with your life. "Why is Adam wasting my time with this...

This month's T-SQL Tuesday is hosted by Aaron Nelson of SQLVariations. Aaron has picked a really fantastic topic: Reporting. Reporting is a lot more than just SSRS. Whether or not you realize it, you deal with all sorts of reports every day. Server up-time reports. Application activity reports. And even DMVs, which as Aaron...

Once upon a time it was 2004, and I wrote what I have to say was a pretty cool little script. (Yes, I know the post is dated 2006, but that's because I dropped the ball and failed to back-date the posts when I moved them over here from my prior blog space.) The impetus...

Hey bloggers! Wake up and get your favorite editor ready. T-SQL Tuesday is back again, this time with a great topic hosted by Mike at StraightPath Solutions. Stop reading this blog and go read his. And then post! As I mentioned to a few Indian MVPs at the MVP Summit a couple of weeks...

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 the second Thursday of the month....

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...

Welcome to the second installment of T-SQL Tuesday, the monthly SQL Server blog party! Last month's kickoff event was a great success, and I'm really excited for this month's theme. I hope that we see even more bloggers, with even more great posts this time around--so please spread the word!ThemeHave you ever found yourself...