Indexing

Dates can easily be the hardest datatype to work with.

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.

Continued »

South Bay .NET User Group, thanks for having me over.

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 »

Speaking at the South Bay .NET Users Group

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.

Denny

SoCal Code Camp - LA #2 has been announced

The SoCal Code Camp website has been reset and is ready for the next Code Camp.  This code camp will be the second camp camp that we are doing up in LA.  This time it is November 21st and 22nd and is being hosted at USC’s campus again.  (There’s a second site setup for the LA Code Camp specifically so be sure to check that site out as well.) Continued »