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 […]
Querying a single table at a time will only get you so far. Eventually, you’re going to need to combine that data, to “join” it, to get more meaningful information. Joins put the relationships into relational databases. Today I want to talk about the various types of joins that SQL Server performs. I don’t mean […]
Yesterday was a pretty full day between training and the ONSSUG June meeting immediately afterwards, so I didn’t get a chance to blog. Anyway, I did learn something yesterday, but it didn’t come from the class I’m taking. Erin Stellato (blog | twitter) gave a great presentation at ONSSUG about statistics. I really wish she’d had more […]
I want to stick with the subject of memory because I think it’s probably the most misunderstood (and sometimes downright mysterious) component of SQL Server. I know I, for one, could benefit from a better understanding of its inner workings. So today I’d like to share that little bit of code I mentioned last week, […]
My research into the Resource Governor question and its answer brought up another question for me: Where does that total_memory_kb number for the default pool actually come from? After all, I have a max server memory of 26000MB for the instance, so why 18175MB? The BOL description for this field wasn’t very helpful. Googling for […]
