Great now I can't get that voice out of my head!

Tonight I get to meet another of the SSC family in person as GSquared is coming to speak at OPASS. Always cool to be able to put a face...

Please share the full table definitions (including any NC indexes) and the execution plans. It would also be helpful if you prefixed each column with the table alias as...

Just remember that ONLINE Index Rebuilds is Enterprise Edition only.

Are both servers 32-bit? Are there differences in server hardware? Is there any data on the local server or is it all remote?

Can you post the 2 different...

I think you want a crosstab/pivot. Check out the 2 articles in my signature about crosstabs.

Index rebuilds if the use tempdb attribute is on then that could be the issue. While trying to find the problem is certainly important, you could also choose to...

Here's a technet article about logon triggers.

Wish I could have been more help. Hope you get it all worked out.

Bob, you gotta quit changing names. You are confusing me!!!:w00t:

Sure that explains it better, but you still have the likelihood of duplicate people if this is an on-going load process. What if Jack Corbett comes across a second...

Chris has given you the right way to code it, but I'll add an explanation. By default any comparison to NULL (=, !=, Like, etc...) returns Unknown, not True...

Hey I think I got the same...

You can't disable the ability to have Windows Logins. You can only not create Logins linked to Windows accounts. You could also write a Logon Trigger that checks...

In order to do a lookup or to even use a Foreign Key you will need to find something that defines a unique person. If you can't define a...