Index Rebuild Status Update And Giveaway!: Quick Tips

I have a Free 1-Month code to PluralSight. There's no catch or gimmick, If your comment is in this post, I'll write your name down and draw it out of a hat and E-Mail you the code. If I can get my hands on a few more, my goal is to give one away every week until the new year. I will give the code away on the Wednesday of each week. (Or at least the first week if I cannot get my hands on any other codes)

Update: PluralSight has decided to give me four 1-Month PluralSight codes! Thank you Plural Sight! I am giving away one each Monday until Christmas! To bring in the new year, I'll be giving away Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton thanks to PluralSight giving these codes out for free.

A quick note, this only works with Online index rebuilds and if you are only rebuilding one index at a time. If you run this script, you will see a percent as long as you run it in the database that you're reindexing. The reason I put this together is that I wanted some way of knowing how far along I was when I was rebuilding a large table. I know there are bigger databases around, but if you're rebuilding a 1.4TB table, It's nice to know if you are 2% done or 97% done before going out for dinner.

I have a second script that has the same requirements but will give an estimate of the time of completion. As noted by a few other people that have looked at it... This one is a bit more experimental.


I'm asking for your help to give me some feed back on it. (This will help get your comment in for the free training too!) Please test this script and let me know if it's within 10-15% of it's estimate. I'm going to go ahead and state that it may be closer to Microsoft Minutes. I've found it to be within 10% accurate on my system... but it needs testing.

Thanks for all your help so far!

Note: The first one is accurate, but the second one may vary. Let me know what you find related to these estimates.

Note 2: This is not a product placement or sale. This is purely something I wanted to organize because of the sheer kindness and help I received first stepping in to the DBA world.