CRM table size sql query

SELECT [total size KB], B.rows,
FROM (select sum(convert(decimal(10,0),dpages)*8129/1024)
[total size KB], id
FROM sysindexes
GROUP BY id) A inner join sysindexes B on = and B.indid in (0,1) inner
join sysobjects O on =
WHERE B.rows 0
ORDER BY [total size KB] desc


One Response to CRM table size sql query

  1. Simon says:

    Slight error in ‘where’ clause; set it to either ‘WHERE B.rows = 0’ or ‘WHERE B.rows > 0’

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Workflow Elements by Aiden Kaskela

Microsoft Business Solutions MVP (CRM), Contractor, Evangelist


Real Experiences from Analyzing, Architecting, developing and working with Dynamics CRM, Dynamics 365 and sometimes .net

Mark Margolis's Blog

It's about Software, CRM, Product Development and sometimes Food.


Gareth Tucker on Microsoft Dynamics CRM

Donna Edwards

Sharing my Journey with Microsoft Dynamics 365 Business Solutions

The Blog

The latest news on and the WordPress community.

%d bloggers like this: