T-SQL Tuesday #005: Reporting
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...
Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys
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...
T-SQL Tuesday #004: IO, IO, It’s Off to Disk We Go!
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...
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 the second Thursday of the month....
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 ever-so-slightly more data, it's possible to make some XML processing...
Invitation for T-SQL Tuesday #002: A Puzzling Situation
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...
T-SQL Tuesday #001 (Date/Time Tricks): The Roundup
Wow! The response to the first T-SQL Tuesday was truly amazing. We ended up with 20 great posts, from all over the world. If you didn’t participate this time, fear not—we’ll be doing this every month from now on so there is plenty of time to jump in. And don’t forget our Twitter hashtag,...
T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR
When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as "gaps". What are the time ranges that we are fully covering? These are known as "islands". If you're unfamiliar with...
Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks
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...
SQL Server 2008: Lock Escalation, INSERTs, and a Potential Bug
Lock escalation is a funny thing. I've found myself on numerous occasions waging war against its concurrency-sapping existence, and rarely have I found myself wishing that it would work more aggressively. But there is a time and place for everything, and yesterday I discovered that a major change has occurred with regard to lock...