Let's see an example for a table:

Let's see an example for a whole database:

Notice When you pass 'true' parameter, SQL Server will automatically runs DBCC UPDATEUSAGE to correct any inaccuracies in catalog views. So if you need absolute size you must pass it and especially after inserting large amounts of data like this:

No comments:
Post a Comment