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
Describe how to use the linked server?
What are window functions in sql server?
How to create “dependant” parameter “make, model, year”
What is difference between materialized view and view?
Explain transaction server isolation?
Who is the owner of a schema in ms sql server?
How to query multiple tables jointly?
Explain important index characteristics?
Explain the cursor lock types?
How do you rebuild an identity column?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is a bit datatype?
What is snapshot parameter in ssrs?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is public role in sql server?
