CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS
Question :
What is a dirty page and dirty report?
Category SQL Server Interview Questions
Rating (0.0) By 0 users
Added on 4/3/2008
Views 600
Rate it!
Answers:

Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)

Dirty reads: Reading the data that is actually read by Transaction2 which was modified by Transaction 1 and Transaction1 was not yet committed and above that, if Transaction 1 is rolled back then transaction2 has read data that never was modified or exists... This is dirty read.





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
What are the new enhancements in SQL server 2005?
View Answer
Difference between a "where" clause and a "having" clause?
View Answer
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
View Answer
Explain real time situation where you would use clustered and Non-clustered Indexes?
View Answer
What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it
View Answer
What are "HINTS"? What is "index covering" of a query?
View Answer
What are data objects?
View Answer
What is the difference between User Identification and Authentication?
View Answer
How to display the table data in XML format using SQL Server.
View Answer
What is XMLA in SQL Server 2005
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL SQL Server Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/14961/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.75