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.

I think certifications *could* help, but they don't, at least not as they're configured. They'd need to be more practical, with a variety of things to solve.

However Jay has a...

Yep, at about 16 months, just learned to walk, started to dance, hasn't slowed down in 7 more years 😀

OK, I'm confused, are you writing the query in Access?

It's not clear what linked servers you have, and where you are querying. If the tables are in Access, then you...