July 2008 - Posts

• SQL Teaser: Where Clause Gone Wild

  Try to guess what this WHERE clause is supposed to do. WHERE r . ApptId IS NULL AND r . DATE >= ISNULL (NULL , '1/1/1900' ) AND r . DATE < DATEADD ( d , 1 , ISNULL (NULL , '1/1/3000' )) AND --Filter on resource ( ( NULL IS NOT NULL AND r . DoctorResourceID Read More... Posted Friday, July 25, 2008 3:24 PM by Denis Gobo | 7 Comments Filed under: Teaser

• Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008

  I was reading Itzik Ben-Gan's An Introduction to New T-SQL Programmability Features in SQL Server 2008 article yesterday after one of my friends allerted me to the following from that article For example, the plan for the following query performs an index Read More... Posted Thursday, July 24, 2008 3:20 PM by Denis Gobo | 1 Comments Filed under: dates, SQL Server 2008

• SQL Server 2008 geography data type screencasts on Channel 9

  Channel 9 has two screencast that deal with the new geography data type in SQL Server 2008. Saving Virtual Earth Polygons to SQL Server 2008 Marc Schweigert shows you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Read More... Posted Saturday, July 19, 2008 5:34 PM by Denis Gobo | 0 Comments Filed under: LINQ, screencast, SQL Server 2008, WCF

• If you are upgrading from SQL Server 2000 to 2008 and you never touched SQL Server 2005, then I feel sorry for you

  “I sense you skipped SQL Server 2005 in you... Skipping SQL Server 2005 leads to a bigger learning curve... A bigger learning curve leads to not knowing the product as well...Not knowing the product as well leads to suffering..Running in compatibility Read More... Posted Wednesday, July 09, 2008 2:33 PM by Denis Gobo | 17 Comments Filed under: sqL Server 2000, SQL Server 2005, SQL Server 2008, Upgrading

• Interview With SSIS Guru Jamie Thomson

  I asked for some names of people who you would like to see interviewed here at Sqlblog and Jamie Thomson's name popped up a couple of times. I contacted Jamie and he was kind enough to take time out from his busy schedule to answer these questions. So, Read More... Posted Wednesday, July 02, 2008 11:06 AM by Denis Gobo | 3 Comments Filed under: Interview, SSIS

• Victim Of The Software Development Meme

  Andy Leonard called me out on the Software Development Meme, so here goes: How old were you when you first started programming? I was 16 and it was on a commodore 128. I still remember the GOSUB keyword :-) How did you get started in programming? I got Read More... Posted Tuesday, July 01, 2008 1:55 PM by Denis Gobo | 2 Comments Filed under: meme, programming