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 create stored procedures with parameters in ms sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
How can you insert null values in a column while inserting the data?
What are various ways to enhance the ssrs report?
Explain trigger and trigger types?
What language is sql server written in?
what is nonclustered index
How to divide query output into multiple groups with the group by clause in ms sql server?
What is tempdb in sql server?
What are “lost updates”?
can SSRS reports Cache results?
What is transactional replication?
How to resolve the orphan use problem? : sql server security
Your table has a large character field there are queries that use this field in their search clause what should you do?
Differentiate between mongodb vs. Sql server?
