TomThomson (1/28/2015)

---

Sean Lange (1/26/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

...

Emil Bialobrzeski (1/28/2015)

---

I've used it actuallt 2 months ago when i occured a log file corruption, long story short, this caused the database to go in suspect state, the database...

Thanks, everyone for your input.

While Jacksonville, FL spent most of the morning in the 40s and only just got up to 53 a little bit ago.

This is...

WayneS (1/27/2015)

---

Congrats Brandie. That sure...

Oh, hey! Let's all go to Russia in the middle of a war!

Dear SQLSaturday Speakers,

This is a one-time system message for SQLSaturday #398. SQLSaturday #398 is coming to you...

Thank you for your assistance, Jason. We are testing out a few options.

Fortunately, these are all non-prod environments, so we can test (almost) with abandon.

Brandie Tarvin (1/27/2015)

---

venoym (1/27/2015)

---

BrainDonor (1/27/2015)

---

Sean Lange (1/23/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

...

venoym (1/27/2015)

---

BrainDonor (1/27/2015)

---

Sean Lange (1/23/2015)

---

Oh the cursors are unbelievably stuipd. They are used to count!!!

set @Counter = 1

while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin

...

So does it recompile each time it runs or did it just recompile the once?

I have just been corrected. Our servers are physical.

Change it to the same size as...

My coworker just sent me this:

BWahahahahaaha.

Brandie Tarvin (1/26/2015)

---

SQLRNNR (1/26/2015)

---

Have him do the trace for the file copy. If the file copy is also puking at about 80%, you can pretty much eliminate SQL Server...