Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / naren
The CHECKPOINT statement saves time in a subsequent
recovery by creating a point at which all modifications to
data and log pages are guaranteed to have been written to
disk.
Checkpoints also occur:
When a database option is changed with ALTER DATABASE. A
checkpoint is executed in the database in which the option
is changed.
When a server is stopped, a checkpoint is executed in each
database on the server. These methods of stopping Microsoft
SQL Server 2000 checkpoint each database
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How to return the top 5 rows from a select query in ms sql server?
What is the difference between dataadapter and datareader?
Is natural join and equi join same?
What do you mean by recursive stored procedure?
What is query processing?
What are magic tables in sql server?
What are exact numeric data types in ms sql server?
What is store procedure? How do they work?
List types of tables in SQL Azure?
Explain indexing and what are the advantages of it?
How to receive returning result from a query?
Write the SQL query to drop, truncate and delete table.
What is difference between count (*) and count column?
How to use linked server?
What is the advantage of sql server?
