The datetime data type can be one of the hardest to work with when it comes to index optimization. Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value. Most people handle this via a convert function around the date column. This causes the index that you create to become useless as the convert function causes the index to be scanned not seeked.
A white paper which I wrote for Starwind Software is now available. The link to register for the webcast (October 21, 2009) has also been put up. The webcast and white paper go together, so I recommend that you grab the white paper now and I hope to see you at the webcast next month.
A couple of weeks back I begun the process of upgrading our VMware ESX 3.5 systems to vSphere 4.0. I’ve got to tell you, that has to be the easiest system upgrade process in history. Continued »
I was going to be doing a webcast next week on September 16th, 2008 on Clustering SQL Server 2008 over iSCSI. Due to some scheduling issues we’ve had to reschedule the presentation for October 21, 2009 at 2pm (Eastern) / 11am (Pacific).
The information page is the same. There’s no registration form on it just yet. that is supposed to go up on Monday for the new date and time. I’ll be sure to put up a new post then.
Tonight I spoke at the South Bay .NET User Group. I had a blast talking with them. They are a great group of programmers. Continued »
Apparently I need to pay more attention to the software that Microsoft has up on the Live site. Continued »
Today I’m publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy. Continued »
On September 10th, 2009 I’ll be speaking at the South Bay .NET Users Group in Torrance, CA.
I’ll be giving two presentations at the meeting. First I’ll be giving my “SQL Server Indexing for the Client Developer”, and second I’ll be giving my “What do all Those Undocumented Stored Procedures do?” session.
The meeting starts at 7, but I’m sure people start arriving about 6:30 or so. This is my first time speaking at this user group, but I’m sure it’ll be a blast.
See you there.
For those of you who haven’t check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on Windows Server 2008. This is an updated version of the article I did last December on Clustering SQL Server 2005 on Windows Server 2003.
I hope that you find it handy. (Subscription is required.)