I'm not aware of any SSIS to do it, however, if the machine that will do the processing has Excel installed you can use some simple PowerShell to automate opening...

I don't know. But if I was going to explore options:

1. I'd check there's no Processor Affinity masks set, and no maximum number of concurrent connections. I know you said...

Also remember that if you begin a transaction and rollback, the identity values will also have increased afterwards. That makes sense if you think about it.

Identity is a count of...

I think I'd have started looking for a new job at that point. I'm in my 30s. I...

It is a generalization, speaking from limited experience, and open to discussion. I'm sorry if you felt I was saying, "every fast learner is like this". Especially...

Wow this really rubs me the...

From the error it sounds like you have two parameters like this:

Parameter 1 (based on Parameter 2)

Parameter 2

If that's the case (I didn't try to digest everything you said) then...

From what I've seen where people actually tested this out, it's no more than 10%. I guess there are environments where 10% is...

Some of those sound fair enough.

I've rebooted a production server once or twice by accident during high pressure events, and once or twice when a patch documented as not...

Thanks for your reply.

In this case I get that I could generate my own...

Yep.

Move the comment header to between the lines ALTER/CREATE PROC and AS.

Sounds like someone's homework. What do you think the answer is?

Gila,

Why did statistics need to be updated when attaching to the new version of SQL Server? I did a little googling but couldn't find a reference for it.

Thanks

I come down firmly against the business in this case; as a huge company it has no excuse to be penny pinching.

IMHO the problem will stem from management. They treat...