Archive for the ‘SQL Tuning’ Category

SQL Server A to Z – Statistics

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

October 24, 2011  Tags: ,   Posted in: SQL Tuning  2 Comments

SQL Server A to Z – Joins

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

August 15, 2011  Tags: ,   Posted in: General, SQL Tuning, T-SQL  2 Comments

Stuff I learned … yesterday – statistics

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

June 8, 2011  Tags: ,   Posted in: Features, SQL Tuning  No Comments

How is SQL Server using all that memory, anyway?

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, [...]

May 2, 2011  Tags: , , ,   Posted in: General, SQL Tuning, Troubleshooting  No Comments

Available Workspace Memory

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

April 28, 2011  Tags: ,   Posted in: General, SQL Tuning, Troubleshooting  No Comments