SqlServer-QA.net

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window in terms of 24/7 usage. By default you can enable of disable this PAGE_VERIFY option by ...

In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid you executing the above 3 statements in a row. Have you ever wondered how long your ...