What's the position on helping someone with understanding technology, but in response to learning or education rather than a formal 'I have a specific issue ....'
I'm thinking of this question,
I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.
From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as possible. At every checkpoint, complete transactions are committed to the data file on the hard drive (that is, they're not actually written to the drive at all until the checkpoint. And the tail always holds the transactions that have not been committed yet.
It's specific, focussed and quite narrow, so it might well get a good answer, but it's not a real problem faced by the person in the true meaning of the phrase.