• So what to do then? I am using SQL server 2008r2 Standard edition on PROD server. I can't block users while I am defragmenting indexes. Is there any option in SQL server configuration or in database configuration where we can find this online option and can make it to available while we rebuliding indexex?

    Please help.