Explain dirty page and dirty report?
Dirty Pages: Data that which is modified and Stored in the buffer cache but has not yet been written in to the secondary storage . Which is Transaction Logs.
Dirty reads: Reading the data that is actually read by Second Transaction which was modified by First Transaction and First Transaction was not yet committed and above that, if First Transaction is rolled back then Second Transaction has read data that never was modified or exists... This is dirty read.