You want to pivot the data. Search for that.

Please don't cross post.

You have to write this again.

You have table valued parameters in 2008, not 2005.

The classic answer is "it depends".

I'm sure you see queries that consume more CPU and eat up more resources. If all users run those, the server can be overloaded, but...

Try this: http://sqlblog.com/blogs/linchi_shea/archive/2007/02/26/maintain-database-partial-availability.aspx

Other objects, views, procedures, etc. aren't automatically transferred. You need to rewrite these in T-SQL from whatever variant of SQL Postgres uses.

Do you mean:

- backup db 1

- delete old backup of db 1

- backup db 2

- delete old backup of db 2

...

The way the maintenance plans work, this doesn't happen. Most...

Try this: http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/

Closing this thread.

I'm not sure I'd be looking to leave right now, especially as many businesses might be fine today, but if they lose business, they'll change the way they structure their...

A nice consolidated list, and I'd urge people to take advantage of the events near them. It's good training and a chance to learn for a fairly small investment of...

Thanks for the update. I thought there wasn't an issue here, and I suspect it might be something else, but your solution is a good one to keep in mind....

http://www.sqlservercentral.com/Scripts/Index+Management/

Perry has a great idea. Get a network number (like 192.168.25.0) that isn't in use on your real network, and assign all the VMs network addresses on this range. They'll...

I've rarely run AV on a server, except for file servers. And then mostly to prevent the spread from workstation to workstation.

For SQL, we've prevented browsing from most of the...