A few changes…

It’s been an interesting month. Today I’ve just come home from hospital having had an inflamed appendix removed. I’m not talking about the back of the book that I set on fire – rather it’s was the reason for a large amount of gut-ache on Monday. I went to the doctor on Tuesday morning, and … Continue reading A few changes…

Missing Index in SQL Server 2008 – should try harder!

Ok, maybe I’m being a little harsh, but I just feel like it should be better. Let me show you the niceness of the way that missing indexes are handled in SQL Server 2008. Using AdventureWorks (not AdventureWorks2008) on a SQL Server 2008 install, if I show the Execution Plan from this simple query, I … Continue reading Missing Index in SQL Server 2008 – should try harder!

Doing the maths to understand SQL optimiser choices

The second of my tips from my talk (slides and scripts available) was about doing the maths to understand why the SQL Server optimiser behaves in the way that it does – particularly in relation to choosing whether to scan an index/heap, or whether to seek a less-suitable index for some of the data and … Continue reading Doing the maths to understand SQL optimiser choices

Presenting at ADNUG this week

I haven’t been to ADNUG for a while. I love that the group is there, but over the past year or more, I haven’t prioritised getting to the meetings. I’ve been to meetings of equivalent groups in Melbourne and Sydney, but not to the Adelaide .Net Group for a while. But this week I will! … Continue reading Presenting at ADNUG this week

Congratulations, Mitch

A good friend of mine from Perth got awarded MVP status this past week. Mitch Wheat runs the .Net User Group over there, and does a terrific job. He does a lot for the community, and is incredibly smart. I’m really pleased for him. PS: There are a bunch of other new MVPs this October … Continue reading Congratulations, Mitch

OUTPUT clause – knowing what goes in, and what you’ve accidentally taken out

The OUTPUT clause has to be one of the best T-SQL features out there. It was new in SQL Server 2005, but it’s still remarkably little known. I guess like many of the features that were introduced in SQL 2005, many people just make do with the way they did things before. The basic point … Continue reading OUTPUT clause – knowing what goes in, and what you’ve accidentally taken out