question

knsk_bsk avatar image
knsk_bsk asked

DBCC SHOW CONTIG returns 0 records in SQL Server 2014 but 2 records in SQL Server 2016

I have a table with records that has Column Store Index. When I run the following in the SQL Server 2014 Version I get no rows.

DBCC SHOWCONTIG ('dbo.myTable') WITH TABLERESULTS, ALL_INDEXES, NO_INFOMSGS

According to one of the documentations(refer below), that I case across, it made sense as DBCC SHOWCONTIG has some restrictions with certain data types like text,varchar,nvarchar etc, and myTable has some of them.

However, when I run the same on a SQL Server 2016 version, I get 2 rows. What I am trying to understand is, does the restriction of DBCC SHOWCONTIG still hold with 2016 edition, or am I missing anything. Were there any changes made in respect to SQL Server 2016 that might give this result.

I do have plans to replace DBCC SHOWCONTIG with sys.dm_db_index_physical_stats, but, still some information about this would be great.

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-showcontig-transact-sql?vi...

SQL Server 2016 and 2014 Versions that I using;


Microsoft SQL Server 2016 (SP2-CU13) (KB4549825) - 13.0.5820.21 (X64) May 22 2020 07:24:35 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)


Microsoft SQL Server 2014 (SP2-CU17-GDR) (KB4505419) - 12.0.5659.1 (X64) May 24 2019 19:09:40 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

dbcc
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.