sounds like checkpointing may have stopped - you get that a lot on slow IO when you have large amounts of memory

try the following

USE TEMPDB

GO

CHECKPOINT

if the script takes more than...

as per the link you posted - each socket is one licence.. therefore 1 8-core socket will count as 1 cpu licence

it supports 4 physical sockets , but each socket is allowed to be multi-core

so you can have 4 8-core processors (32 cores) if you want

i just did the same thing for a UDT (as per the original post) rather than a table type and you seem to be able to do it.... possibly because...

as you can see from my example - i didn't touch the proc - just the UDT

you should really do this on a dev server and send it for test before you even think...

i know since sql 2000 there have been some changes to the way queries are evaluated... you get the same type of errors is you try and insert from a...

My Company is a huge user of Cloud services (we consume about 250Gb of new data a day) and although there are some drawbacks (IO performance is appauling etc) the...

Changing the recovery model to simple is not recommended for the fact it will break the chain of the log in case if you are having log shipping or database...

in that case (depending on how dilligent your test analyst is and what methods/tools they are using for the test) then i would just leave it alone - any...

in that case (depending on how dilligent your test analyst is and what methods/tools they are using for the test) then i would just leave it alone - any...

what kind of testing ?

performance testing (soak, stress, load tests)?

functional testing / Unit testing?

environment/patch deployment testing ?

joe.eager (7/5/2012)

---

I've been beating my head against the wall for a bit with this problem and was wondering if anyone could point me in the right direction.

Background: I was...

are you doing index rebuilds or index reorganisation? it sounds like a rebuild

if it is a rebuild then changing the t-log backup schedule would be pointless as the entire index...

i can see that in some cases using an IF statement might make huge blocks of duplicate code, but i can't see any performance issues

regardless you can do the following...