Are you rebuilding all indexes before this? That would cause substantial changes and make the diff approach the size of the full.

If you run a full, and then run a...

What "didn't work"?

The group by is what I'd be looking to do as well.

You could self join as well. Is there a primary key field?

I assume you connect to the instance fine with SSMS or other tools? Is there any other process connecting to SQL? What happens often is that the install looks...

Microsoft and others do publish information, but you have to dig for it. The biggest issues I see is that their sample apps are often cut down, and don't always...

Heaps have nothing to do with database structure. They mean you have a table without a clustered index. I assume you have indexes, make one a clustered index on each...

Not sure if it includes a CD. You can check on Amazon if one is listed.

This is related to SQL Server in that a geoid is used as part of the basis for spatial modeling in SQL Server 2008

Not in 2000, and it's a bad idea. Even the mirror'ed backups in 2005 have issues. If one fails (one drive, network, etc.) both fail.

Don't do this. Back up locally,...

You might have a lack of memory, slow disks, poor code, too hard to tell.

I'd suggest that you start with looking at heavily run queries and trying to tune them....

Note that I've received a complaint on this thread.

I don't think anyone has crossed a line, but I see a few posts that are close. Please remember that this is...

LOL, that kind of defeats the purpose of connecting to master.

I think the only thing you can likely do here, is connect as admin, then pause the server. That prevents...

You shouldn't need to be in the database to change to multiple users. Connect to the master database as a system administrator and then alter the properties of the database.

You could purchase a license to SQLSentry, which will help you handle this and prevent them colliding with each other. Otherwise, I like Mani's solution. Just look at history, schedule...

I'm a little confused about what you mean by the awards and then the two approaches. Can you post a bit of sample data and explain how you see the...

I'd go with what pradeep has suggested.