We are using Sql Server 2008. I have no idea what the specs are pertaining to the database servers but I agree that's a good place to start asking...

Thanks guys!  That does help clear it up.  I was not in favor of using that approach (i.e. allow nulls) but my co-worker was very much for it.  So I...

Thanks to Michael Rys and his blog for helping explain this.  The article below was lifted from his site and gives a good explanation of whats happening.  I think we will try...

that's exactly what I needed. Worked great thanks! Just in case anyone else wants to use it, don't include the GO keyword and also watch out for the...