if you can't reduce the size of .mdf file, I think you should STOP auto growth on the drive which is almost full and add a .ndf file on different...

if you are using Maintenance plan, one point you will have 2 backup files around 800 GB. you need more than 800 GB to take backup thru MP.

Right now,...

Hi Jeff,

Since BLOBs live in different table, if I want to know 'what's the size of each row?' does the 'Data' contains (from sp_spacesued 'tablename') BLOBs too? And what about...

I only run 'rebuild' job> 30 percent with 'Limited' option. will you share Ola Hallengren script here? it's kinda hard for me to put together.

Thanks David Moutray for your reply. I ran this script:

-- When were Statistics last updated on all indexes? (Query 51) (Statistics Update)

SELECT o.name, i.name AS [Index Name],

...

Thanks for your reply.

Thank you very much!!!

Thanks you so much guys!!!!!

Hi Jeff,

After i divided size (KB) with Rows it came out 30 KB (around) size for each row. So each page contains 8 KB. So a row on my table...

Hi Scott,

I got the following results, but didn't get it. Would you mind explaining please?

total_max_row_length

1461

data_length

1415

var_lengths

32

bit_map

3

general_row_overhead

11

I created a table using all same column and datatype and ran as you said but it came out 0s !!!!

Grant, that's what I thought. I just googled it says 1 Kilobyte = 1000 byte. Backup_set is in bytes according to BOL. I am trying to figure out backups size...

I use Maintenance plan (Maintenance Cleanup Task) and point to the folders where backup files stores.

Thank you Grant!!!

Grant Fritchey, Can you please put your inputs about what exactly I have and what's the 'MaxDop' no. should be?