| |
|
|
| SQLUSA.com
|
|
|
 |
|
|
| How to
use the CHECKPOINT statement? |
|
The CHECKPOINT
statement forces all the dirty pages for the current database
in memory buffer to be written to disk.
Dirty pages are
data or log pages (a page is 8K) modified after entered into the
buffer cache, but the modifications have not yet been written
to disk.
You would use
CHECKPOINT after you shrank the database using DBCC. Without checkpoint
you may not be able to see the results of the shrinking until
the server does an automatic checkpoint.
Related article:
CHECKPOINT (Transact-SQL)
|
|
| |
| SQLUSA.com
Home Page |
|
|
SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
|
|
|
FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com |
|
Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts |
Copyright 2005-2012, SMI Corp. All Rights Reserved.
SQL Server 2012 is a program product of Microsoft Corporation. SQL Server 2008 is a program product of Microsoft Corporation. SQL Server 2005 is a program product of Microsoft Corporation. SQL Server 2000 is a program product of Microsoft Corporation. |