UPDATE STATISTICS dbo.Study WITH FULLSCAN DBCC SHOW_STATISTICS ('dbo.study','pk_study') SELECT COUNT(*) AS [RowsInTable] FROM dbo.study