A file copy v a backup are two different processes. There's not much you can do to tune the backup process in SQL Server.

Can you show your script? ...

This should help you:

http://msdn.microsoft.com/en-us/library/ms143731.aspx

If you are at the target memory, then you are fairly close to what is needed.

Having heaps can be a problem for performance, but not necessarily. Is there a reason...

This is really an I/O subsystem issue, and less a query tuning issue. The load from your server exceeds what the I/O system can handle.

http://mssqlwiki.com/2012/08/27/io-requests-taking-longer-than-15-seconds-to-complete-on-file/

Tuning queries to use less reads...

You are missing some data here. How can you tell an actionid for an item has been completed when the first table doesn't have ItemIDs? You have two actionIds of...

Forecast this week

For a web application, you should need a per processor license, based on the number of cores.

I don't see anything on the ALTER TRIGGER syntax, but here's Merge: http://msdn.microsoft.com/en-us/library/bb510625%28v=SQL.100%29.aspx

The idea was that all statements would require a semi-colon, which might help the language mature and enable...

Miles Neale (12/17/2012)

---

Could Microsoft do that in a new area in the "Microsoft Store"? Could you view a page that using some form of AI asks you and assists...

David.Poole (12/17/2012)

---

If you can't understand the licensing model then how can you be sure you are in compliance with it?

I've actually had two conversations with different Microsoft resellers who contradicted...

Great catch and thanks!

It's fixed

Which original story? Losing power in a data center? That's a DR, technology related issue.

Companies trying to be sure their data centers are running after hurricane Sandy, that's DR....

Or backup/restore the entire db, then remove the data you don't need.

No good way to do this, but if I were choosing, I'd use SSIS as Gail suggested.

Look at the data, preferably from the application, and find some data that comes from both tables. Then find those rows in sSMS and see if you can derive a...

Eric M Russell (12/13/2012)

---

Database cloud services in 2012 are sort of like web application frameworks back in 1996; the basic technology infrastructure is there, but folks are still debating about...