Subscribe to this blog
Tim Radney - Database Professional
Archives: May 2011
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A co-worker was working on an ETL process when he discovered that using “NOT IN” in a sub query with a data set that contained NULL values was giving him incorrect… Read more
0 comments, 410 reads
Posted in Tim Radney - Database Professional on 31 May 2011
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL 2000 to SQL 2005 (app not yet supported on 2008). This time around I decided to do things the right way and migrate from DTS to SSIS not just import… Read more
1 comments, 393 reads
Posted in Tim Radney - Database Professional on 17 May 2011
SQL Saturday 74 – Jacksonville FL
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak about SQL Server. This was my third SQL Saturday to present at and my fifth SQL Saturday to attend. I should mention here that I am also now planning a… Read more
0 comments, 213 reads
Posted in Tim Radney - Database Professional on 2 May 2011