Scott, my concern is a size of a row. As Grant said UNIQUEIDENTIFIER is 16 bytes. if I have 503 columns with datatype 'UNIQUEIDENTIFIER' and rows are empty, will all...

Thanks spaghettidba and djj. Appreciate it!!!!!!!

Thanks for your reply spaghettidba. It's hard for me to put Ola's script together. I would appreciate if someone post a script here <30 reorganize, >30 Rebuild Index.

spaghettidba, can you...

Thanks Perry. You are right, BLOB and Max data type..etc. cannot be compress.

Thanks Jasona.work, appreciate your reply. Last question, since I have 4 data files ( 1 .mdf, 3 .ndf), which file should I shrink? Any suggestions or best practices?

Thanks Zzartin,

I am trying to RECLAIM the drive space, so should I go with shrink database or shrink file option? which one is safe and best practice?

Little confused. Should I shrink database or shrink files (got one .mdf and two .ndf)??

Worked!!!!Thanks you millions Kutang and Jeff you guys are awesome:-)

did this: exec sp_spaceused 'AdventureWorks.person.address' still not working 🙁

Thank you Alvin Ramard and SQL 1. How do I claim the space after the delete.

Thank you all smart folks 🙂

No sir, trying to do on a 'Test' so I can do it on Prod.

what if there are more column with GUID? what do you suggest please.

Thanks Mr. Jack

Thank you guys!!!