going Computer Management --> Disc Management and reviewing the 8 drives that are for the SQL server data files all are showing the same exact size (150 gb's)

Yes sir...a right click on the drive --> properties displays the...

Sorry the radio button is selected to 'Show hidden files and folders'

Hi...

GAH!...I was using an online converter and it displayed to values Binary and SI...

Didn't look at the Binary which is indeed correct and displays 143 gb's

Thanks for the check for...

I had not until your post (didn't even think about it since windows explorer seemed to show the correct size...and the same with spacesniffer.exe.

SO...

Control+F on the drive...add criteria for files...

Hi Gail,

Just wanted to stop back and thank you for the link and information.

I got that script working, ran it and have been studying the logic in it to get...

Hi Gail,

I don't want to sound like I am beating a dead horse and I did read your reply...if that is common knowledge I didn't know.

Your comment

The higher levels of...

GilaMonster (1/7/2011)

---

In general, in most cases, worry about the leaf level and no other. The higher levels of the index are generally not large enough for fragmentation to matter, and...

OK does this make sense...I was just reading a wonderful article by Gail Shaw (Thanks for the article)...

http://www.sqlservercentral.com/articles/Indexing/68439/

This is probably going to sound nice and stupid but is...

Hello Roy,

I had reviewed the BOL regarding that stored procedure and I was under the assumption that since I am running the procedure on a SQL 2005 server which replicates...

Thanks for the comments!

Are you referring to the script? If it worked glad it helped!

Thanks much for the post...I plan on coming up with a short demonstration (script) for the individual to validate the process of the backup and any changes that happen during...

Like others have said, there are pro's and con's...