LOL, in an interview, I'd think the CTE, or a short WHILE loop would make sense, having the person talk through what they're doing. This isn't a test of great...

One other thing is that "common answers" change over time. The T-SQL langauge has changed (index defrag v alter index) over time, and at the rate MS releases versions, I...

I visit a lot of forums and they have similar issues. Most people won't read a "sticky" post at the top of the forum. They just don't pay attention. Those...

The ask.sqlservercentral.com is supposed to help here. Not sure if it is.

Not sure there's an easy solution for this. Most people just want to ask a question and get an...

Are you "loading" data or is this users making changes? If it's the latter, which is what most systems have, it's impossible to do anything other than guess without historical...

I'm confused what is happening. Can you explain it a touch better?

I see it. That is strange if you're not seeing it. Should be no linkage between the two.

BIDS is a tool, it isn't a way to find a job. No one advertises or asks for someone that has skills in BIDS. Anyone asking for skills would be...

At the time we had 3 compression settings (light, medium, high). They result in (in order), less compression, good compression, heavy compression, meaning most disk space, middle, least disk space.

If...

The technical reason is that it's not support. http://msdn.microsoft.com/en-us/library/ms143393%28SQL.90%29.aspx I don't believe setup will allow this.

Can you do it if you handle the uninstall/reinstall, attach dbs, move jobs/logins/packages with scripts?...

You need space on the server for a backup. Remove backups do not tolerate any delay, and any network hiccup, which happen all the time, will fail the backup. File...

Agree with ChrisM. Barry has good advice, but be sure you test extraction as well.

I'd go with GTs advice, though replication has worked pretty well in small situations without worrying about agents.

I'd script the shutdown of the subscriber agents (use SQLCMD) since you'll likely...

yes

and

yes, maybe.

All of this requires testing. Moving to temp tables could help, but you would have to run a lot of tests, probably some on the live system, to...

I think it's a tough one and a toss up. You might not be able to get more/better CPUs easier than disk in an enterprise box. It could easily be...