SQL Server doesn't do table backups. It does database backups and you can search for scripts to handle that. The Maintenance plan can also do this.

The issue is that SQL backups are extremely intolerant of network delays. A file copy will retry itself, but because of the nature of getting the backups done quickly, it...

I've read the Ender series, which is good, as well as the Foundation and Dune series a long time ago. Never any of the add-ons, but I might check them...

What Colin and Jeff are getting at is that the CPU isn't related to the number of users. It's related to the queries and other processes. One user can run...

Colin,

I had heard that the 64-bit OS has less overhead than the 32-bit one because no AWE/PAE paging space needed for paging. Is that true?

Does the 64-bit OS need 4GB...

One more vote for hiring someone. You'll need them even with a tool.

Tools do help, but you should match the tool to the DBA if you can.

Or this: http://www.sqlservercentral.com/articles/Stored+Procedures/2977/

I don't see a good way to do this, even with a cross join. You'll get more cross join stuff out of there.

If this is of any size, you'll run...

Ah, I see.

The problem is that you have matches and you're really looking for some sort of cross join that displays all possibilities. Then you need to somehow join...

I hate tape agents. There have been numerous restore issues documented with these agents. It might be better with later vesrions, but I highly recommend not using these agents for...

How do you get the data in the third column? It doesn't make sense from your data example.

Thanks for sharing, but please post in the appropriate forum for your product and issue.

This has been moved to the Express forum.

Track it over time.

No idea. Represents time waiting? Watching the sands of time?

http://www.amazon.com/Professional-SQL-Server-2005-Programming/dp/0470054034/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1199123761&sr=8-1

I might start on the web and search out SQL Server 2005 CLR Programming.