Sue_H - Friday, March 24, 2017 3:23 PM
Yup he did write most of CheckDB. That said, some important notes from the article are found in the comments:
1. Paul always recommends a full checkdb on a weekly basis at minimum with the exception being extenuating circumstances.
2. Jonathan has a great article concerning the performance of checkdb and an article linked in the comments (pertains largely to vldb and it should be read).
3. Read the linked article by Argenis about an extenuating circumstance in his vldb and sparse columns with indexes.
And since we don't truly know the version of SQL Server the OP is using, we need to take into consideration what will be missed if a checkdb is not performed in favor of the broken up approach such as:
SPATIAL INDEX
XML INDEX
Query Store
ColumnStore
Filestream checks
Service Broker
These are some of the reasons I am sure Paul still recommends a full weekly checkdb.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events