Back To Basics: What’s the difference between a Scan and a Seek?
There are a few basic operations which SQL will perform when looking for the data that you need. Here they are listed in the order of worst to best. Table Scan Clustered Index Scan Index Scan Clustered Index Seek Index Seek The basic rule to follow is Scans are bad, Seeks are good.
ITKE is getting an upgrade soon
I’ve been informed that at some point in the near future (within the next couple of weeks probably) that we’ll be upgrading the version of Word Press that we use for the blogs.
PASS 2008 Wrapup
Well the PASS 2008 summit must be official over as I’m sitting at the airport waiting for my plane. I was expecting a very long security line here at SeaTac but I was through security within maybe 10 minutes. While means that the two hours I was planning on standing in line I instead get […]
PASS 2008 – Day 3
Today was a pretty slow day. I spent most of the day kicking back in the MVP room talking to the MVPs and the Microsoft folks. I did make it to a couple of sessions however.