This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing DBCC CHECKDB with option EXTENDED_LOGICAL_CHECKS of SQL Server.
If you execute only DBCC CHECKDB, excludes other logical checks like persisted columns, indexed views, filtered indexes which improve the overall performance of it.
If you run DBCC CHECKDB with option EXTENDED_LOGICAL_CHECKS, it does logical checks like indexed views, XML indexes, and spatial indexes.
You can also use EXTENDED_LOGICAL_CHECKS with DBCC CHECKTABLE.
The syntax is:
|
1 2 3 4 |
DBCC CHECKDB(Db_Name) WITH EXTENDED_LOGICAL_CHECKS GO DBCC CHECKTABLE(Table_Name) WITH EXTENDED_LOGICAL_CHECKS GO |
Leave a Reply