Thanks for the feedback.

I was about reading to get my brain checked over this one! 😀

Ok, but where's the advanced stuff? :hehe:

Ok so take 3 months off, checked!

Brain surgury, checked!

When you rebuild the server makes a 2nd copy of the index (if clustered, then the whole table). Then there's a little more overhead.

Thanks for all the help,...

Paul Randal (8/10/2011)

---

You need a UPS so the current fluctuations don't mess with your systems.

Don't worry about it - too much hassle going through client agreements etc - it would...

I've had the service NOT start after 1-2 installs. Just go in services and start it.

If connecting remotely you need to start the sql browser service as well.

Need to...

@paul-2, do you have other presentation like teched that cover other cases? I'd love to learn more on the subject.

I'll also try to repro the error. But considered...

Paul Randal (8/10/2011)

---

Ah - if it's business data from your company I won't download it to our systems unless you're a client covered by an NDA and our business liability...

Now they get generated. But I don't have a dumpable test server to try and run it so I'll have to leave it at that for now.

You never posted that code in this thread, so assuming it's containing today's midnight datetime...

>= @todaymidnight and < dateadd(d, 1, @todaymidnight)

Paul Randal (8/9/2011)

---

There are hundreds of cases I didn't talk about in that presentation - but glad you liked it!

Sounds like memory corruption of a log block changing the slot...

You do what you have to. I'll keep on this side of the line :-).

@paul-2 : How many cases do you have to contend for?

Now I'd like to explore the scenario where I do have a full backup + full recovery.

Would I have...

Ninja's_RGR'us (8/10/2011)

---

Am I clearer by saying this instead?

sp_updatestats AND updatestats X keep the current sampling rate

UDPATE STATS WITH <fullscan or smapling rate> overwrites the old setting and saves the new...