What is Check point? Explain in Brief what it will do?
Answer / 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 |
What are the two types of concurrency?
What is join and name different type of joins?
What is ddl and dml commands?
What is sql server 2000 work load governor?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
List down some advantages of sql stored procedure?
List some major differences between triggers and stored procedures?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain the use of containers in ssis and also their types?
What is the difference between mysql and mysqli?
How many types of database relationship in sql server?
what is the Enterprise manager(2000) and management studio (2005)?