That's a highly incomplete link, and it's what was said before.

The hard part is determining

- records/month

If you know that, then it's easy. But getting that number can be very...

Ditto

Sorry I misssed it

richard-674310 (2/22/2010)

You might want to consult your HR department on this - if you have one. I think it may be illegal (in the UK) to discriminate on NON-OBJECTIVE...

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.