If you want to use Powershell here, I found a cool script from SQL Chicken: http://sqlchicken.com/2010/06/powershell-i-heart-you/

Someone should tell the NBA refs that. A bit too many calls in the first three games.

Soccer is great exercise, it is a chess match, but it seems that it...

Are you running Express on your laptop?

Sounds like you are doing the right things. I wouldn't think it's R1, but possibly just a load issue on that hardware/version.

R10 works on...

You can do it, but be careful. You likely want to set the max memory for each instance, and you are competing for resources. So it's not as simple as...

If you have Express, memory probably won't help. Are these all older disks? Query tuning perhaps? Post a set of DDL and sample code in new thread and see if...

No errors coming back? Could it be security context somehow?

JF, I posted a note to people to see if someone wants to help you out.

As a short note, when you run queries on your laptop, are the data sizes/sets...

I thought there was a checkbox in DTS to handle identity columns, but basically you cannot directly insert into an identity column without marking it as available for insert.

Good point, Jack, and I hope we'll see you on the board soon 😉

We should also be embarrassed if we lose at basketball.

A nice blog, in the spirit of Jeff: Killer I/O

Elliot,

That should work. Couple things to be aware of. If you have Enterprise edition, you should be able to restore one filegroup and get working while the next restores. IF...

Yep.

SELECT cntr_value, *

FROM sys.dm_os_performance_counters

WHERE counter_name = 'transactions/sec'

AND OBJECT_NAME = 'SQLServer:Databases'

AND instance_name = 'AdventureWorks'

http://msdn.microsoft.com/en-us/library/ms187743%28v=SQL.100%29.aspx

I've done it, and I learned by digging in years ago into ASP and ASP.NET. Just getting a project going, and slowly learning how one thing learned, how it fit,...

New levels here: http://www.sqlservercentral.com/Forums/Forum83-1.aspx

Feel free to add comments, or make suggestions here.