Yes, I know you just got back from the 2011 Summit. Kinda like I just got back from vacation. But that doesn’t mean I haven’t already started thinking about my next vacation. And you should be thinking about next year’s summit. Why? Because until November 15, 2011, you can register for only $995. Seriously. You […]
I may be on vacation, but the alphabet goes on. We’re up to the letter T and that stands for tapas, toreadors, and tempdb! Tempdb is a system database with one very special characteristic: it gets recreated every time SQL Server starts up. What is tempdb used for? The first use for tempdb is user […]
I may be on vacation, but the alphabet goes on. We’re up to the letter S and that stands for Seville, siesta, and statistics! Suppose you’re invited to join a fantasy football league, but you know absolutely nothing about any of the players (maybe that’s why you were invited). How do you know which quarterback […]
I may be on vacation, but the alphabet goes on. We’re up to the letter R and that stands for rest, relaxation, and recovery models! Recovery models define how SQL Server manages the transaction log for your database. You have three options to choose from: Simple, Full, and Bulk-logged. The model you choose will determine […]
Today’s post is brought to you by the letter Q. In SQL Server, the biggest thing that Q stands for is Query. Obviously that’s a mighty broad topic, so today I’m just going to go over some best practices for writing queries that I’ve learned over the years. Nuggets of T-SQL goodness List out the […]
