SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Tim Radney - Database Professional

Tim Radney - Database Professional by Tim Radney I am a Sr DBA for a top 40 US bank. I live in the south eastern US. I have been working with database since 1999 but only full time for the past three years.

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, 1,342 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, 1,090 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, 865 reads

Posted in Tim Radney - Database Professional on 2 May 2011