GSquared (1/18/2012)

Tropical islands are usually near the ocean (go figure), which operates as a heat moderator. The only two US states that haven't broken the 100F mark on the...

It could only work any other way if the backup...

Me! Sounds far too...

It's really hard to answer a question like this, because it's not a position I've ever been in...the idea of being in a situation where I literally could do what...

I'm not an expert by any means, so take anything I say with a pinch of salt, but shouldn't "genre" be separated out into another table? Seems to me it's...

Can't you do this without a 3rd-party tool by just starting SQL server in single-user mode?

The weird thing is, I selected the first two answers because I wanted to see the *real* answer, and ended up getting the question right more or less by default......

Does it still affect performance if you move the b.Col7 to *after* the selection list for a, as it is in the first example?

All I want for Christmas is a lottery win! 😛

Not sure about your other questions, but "Local System" is a special account which is only used to run services--it effectively has better than Administrator access to the local machine,...

I would ask, though--why do you need to RDP to the server? Most of the work you should ever need to do in SQL server can be done via SQL...

How many processor cores do you have on that machine? I recall that there can be problems installing older versions of SQL server on machines that have a number of...

Because doing a shrink will fragment the indexes again, thus making...

I think it was resurrected by a spambot post which has since been deleted.

You might not consider it...