Friday, 3 August 2018

Manually Checking Table Statistics

How to examine table statistics and update them if necessary
UPDATE STATISTICS  dbo.Study WITH FULLSCAN

DBCC SHOW_STATISTICS ('dbo.study','pk_study')

SELECT COUNT(*) AS [RowsInTable] FROM dbo.study