I think part of it you can decode like your data, page no which was modified , record size . I will just show a small thing here

-- create a...

Paul,

I that case I should also focus that I mentioned

"Check if defrag is required"

Cheers

V

Hi Paul

Thanks for your inputs.. Its a small ex I have put down

-- create a db

USE master;

GO

IF EXISTS (SELECT 1 FROM sys.databases WHERE name = 'Page')

DROP DATABASE Page;

GO

CREATE DATABASE...

1. Yes , you will have to shrink the data files in order to release that space from that database. (Shrink might require considerable downtime)

2. Check if defrag is required,...

You need to take care of the following things

1. Is the table partitioned. If not it would be great if you could partition it?

2. Based on the querying needs you...