Am i right in thinking then that data doesn't "move" from the transaction log (ldf) to the data file (mdf). The database engine modifies data pages in the buffer,...

It won't work in SQL 2000. The query uses Dynamic Management Views which were only introduced in SQL Server 2005.

Excellent article that I'm sure will come in handy...

Thanks for the suggestion Roy. I did try this to start with but the publication started generating lots of articles which is the part of the process that took...

Much appreciated Gail. The term "to disk" always confused me. I never knew whether it referred to the data file or the log file. Your response has...

Excellent article Gail. Any chance of an overview of the SQL Server operations which take place internally. Am I correct in thinking that a checkpoint flushes the buffer...

+1. I have so many applications for resource governor, one such use came to mind this morning, where we have a third party application which lets users run adhoc...

Thanks Steve. Hopefully it'll be ok this morning. I appreciate you taking the time to advise me.

Kind regards

You were correct Steve. The publication was finally dropped. :-D...

Thank you for your reply.

That is split between tables and other objects. When I recreate the publication I will omit the non-table objects. Do you have any...

Thanks for posting this article. Very cool stuff, which I will no doubt be referring to in the future.

This question is open to ambiguity IMO. I went for 3 - Heap, clustered and non-clustered.

http://msdn.microsoft.com/en-us/library/ms180978.aspx

Good learning question, a real tough one.

An excellent question....which I got completely wrong....I hate these "select all that apply" questions 😛 Thanks for the learning experience though.

Excellent question. I can't see any issues with the wording - latest differential backup, to me at least, means the latest usable differential backup, ie the one which doesn't...

An interesting and informative question. Thanks

Took a guess and got the correct answer. Couldn't see the point in the question, unless it was teaching that this functionality existed. Thanks very much for the...