I already bought this book, and love it. Itzik is a terrific writer and thinker, and often asks much of his readers. If you don't win a book...

Yes, but is what I said false because of that?

Besides, Marcos's post was only 2 years old 🙂

I think that you will never see all zeros because one VLF is always in use. What you need to see is 2 near the beginning and zeros at...

Joie Andrew (8/8/2013)

This...

James Stephens (6/18/2011)

---

Hi all,

I have a related question that I think was somehow answered in the above posts but I just wanted clarification for academic purposes:

Suppose I change a field...

Agreed. I think that's all included in the article.

But specifically, when the transaction that has made row changes is checkpointed and not committed, and for whatever reason needs to...

Thanks for starting this series, Tony. It will be good to have a complete transaction log reference

Could you clarify this:

Data is modified in the data cache, and the log...

Like GilaMonster, I did it backwards, and looked for the two that wouldn't work.

Paul Randal just tweeted that DBCC CHECKDB will trigger it as well.

I am honoured that Hugo agrees with me. 🙂

If you feed your own values into the function, then...

That was my understanding, but the supplied answer seems to say that the function will...

I'd be interested in your answer to these questions:

If you're using TDE in a production environment, what do you think you are protecting yourself from?

And are you using TDE on...

READ_ONLY on model is not copied to new databases? Good to know.

Being able to put READ_ONLY on model so that your changes are not modified? Darn useful.

However, you'd...

+1

I got it right, but there's something unclear to me in the explanation:

* A log backup that contains a minimally-logged operation cannot be used to do a point-in-time restore (i.e....

Thanks for the article. I understood HSM only very vaguely before.

I'm concerned about your use of "allow updates". I was sure that this was removed from SQL 2005...