Thanks, I agree with all your statements.

Our IT architect wanted to restore from VM image and bring back into sync.

My thinking was that we had to restore from backups and...

Correct, it is like the load balancer to the web farm in that it sends connections to the appropriate server.

Are you connecting to the listener or to the instance?

You should have a listener to connect to that redirects to the appropriate node depending which node is primary.

So there should...

Eric M Russell (9/23/2015)

---

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is a single transaction, and...

AH of course!

I see, using row number twice and subtracting to find the difference to create the desired output.

Perfect, thanks!

That never even occurred to me, I was playing around with...

Does that still hold true, even without the stored procedure?

The part "protecting it" is due to the parameterization?

DECLARE @MyParm AS CHAR(50)

SET @MyParm...

So the listener is "for the availability group" not the instance itself, which makes sense if I think about it that way.

Is that correct?

it has no concept of instance name?

I found a image online that shoes this (article was about custom roles but didn't happen to mention why they had the same red pins)

However, further reading tells me that...

So you need to be sure to specify to only use the # of cores you licensed then, right?

Well now I'm curious.

If you paid for 8 cores but have 16, does the license key only allow SQL to map to the first 8?

I assume it won't use all...

Yeah, sadly I think I am going to have to drop and re-create.

I'm going to try just migrating data disks to new VM first and see if it just "goes...

Just for fun, I DISABLED Instant File Init on both servers and ran the same create statements:

fast server - 5 seconds, 7 seconds one time

slow server- 80 seconds (so basically...

Conor Lillis (12/5/2014)

---

I wonder are the SQL Services on the different servers running under accounts with different privileges?

If the [SQL Server] Service account has the privilege "Perform Volume Maintenance...

Yeah, I'll look at loading up adventure works and running a few queries.

Issue is going to be though, that once it caches adventure works I would expect normal performance, only...

No I have not.

Probably wouldn't be a bad idea by any means.

Any suggested ones to look at for this?