These are huge topics. It's not something you can do simply.

Here's a link to get starteD: http://www.sqlservercentral.com/articles/70199/

Saw this today. Have you read it?

http://bit.ly/aUh6S

Not that I know of. The counters have to be captured somehow. If clients don't want to do that, then I guess there's nothing to be done.

No idea there. I'm around 21k or so ,and I go 4k a year, so that's a ways away for me.

You can use SETUSER as an admin to check.

Public shouldn't have rights, so be sure there's no deny on that, and check their permissions. If you can't find anything, you...

Jeff Moden (6/10/2010)

---

Heh... I'm going to have to jab my mind's eye out on that one. :pinch: I just got this really live and frightning image of you...

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 😉