You've hit bugs in rollback - contact PSS and they'll work to get a workaround and fix. Nothing much else to do without being able to step through the code...

Cool - if you can email me the setup script I'll play with it this weekend! paul @ sqlskills.com

In that case you should call Product Support to help you out.

Your question is broken.

The correct answer is the rebuild, but not for the reason you say. The table in question will not have more than 8 pages and so they...

http://www.sqlskills.com/T_MCMVideos.asp

More presentations - yes, but not recorded.

Restore behavior - yes, as you've described.

Getting things back without data loss - no, of tail-of-log is corrupt.

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 need the...

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 insurance. Sorry.

So...

I don't have a publicly available ftp upload space - if you can post it somewhere, I'll download it.

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 number in...

Cool - no hard feelings.

Yes - plenty of times when data volume has grown beyond the capacity of the buffer pool because memory has also not been expanded.

Dude - you start flinging insults around and you expect the conversation to continue?

I've seen plenty of servers with high PLE (tens of thousands) that had perf issues which killed...

pkrudysz (7/30/2011)

---

I totally disagree with people saying that PLE (Page Life Expectancy) of 300 is an irrelevant number and how we should all watch our servers and look for deviations...

Sigh - another article mentioning 300 as a threshold for Page Life Expectancy. Go read this article that explains why 300 is nonsense.

Also, low PLE or BCHR does NOT mean...