Interested to Buy Any Domain ? << Click Here >> for more details...
What is Check point? Explain in Brief what it will do?
- 1 Answers
- 6056 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
When we done operation on SQL SERVER that is not commited directly to the database example:we are deleting bulk records from server but in between power shut down or some thing happened then that transaction is not committed from our side if we create check point on that delete statement after deleting some records it will save as check point next no need to delete those records again if check point is not there means we have to start form scratch.All operation must be logged in to Transaction Log files after that they should be done on to the main database.CheckPoint are the point which alert Sql Server to save all the data to main database if no Check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER.When we stop the SQL Server it will take long time because Checkpoint is also fired.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is CTE in SQL
Explain the microsoft sql server delete command?
How does clustered and non clustered index work?
Define magic tables in sql server?
What is 2nf in normalization?
What are views used for?
What is sql server transaction log file?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to use subqueries in the from clause in ms sql server?
What is normalization 1nf 2nf 3nf?
What is the sql case statement used for? Explain with an example?
What is partition, how will you implement it? : sql server analysis services, ssas
What are the differences between web role and worker role?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is function of ROLLUP ?
