question

With all due respect, this looks like a homework-type question - and those tend to get a better response on forums if you can show the work you've already done; for example, if you know how to do the tasks but not how to get the scan densities, then show us what you *can* do. What you are being asked to do here is not too complex, but us giving you the answer doesn't mean that you know it - better to show us where you are stuck (and where you're not) so that we can point you in the right direction for the rest.

I couldn't make out how to use that rebuild option for below 60. I mean how should i say that it should be rebuild or reorganized. I tried it with case when statements but we can't use alter statement to that and later i tried it with SQL Server Data Tools using Rebuild Index Task but I'm unable to give an index name and table name to that using SQL Execute Task. Currently I'm stuck there. I need your help.

I'd look at the T-SQL in the article Grant linked to - that will help you identify which to use. As to how do do the conditional steps, you're right that a case statement won't directly do it, but you could (for example) use a case statement to trigger a job or call a separate module to start the process of a rebuild.

But i want index name and table name from the retrieved result set to use them in rebuild statement. so how can i get that?

In the function mentioned in the article liked by Grant there is a column being returned that will help you get both index and table name. Build a query that will get you fragmentation, table name and index name, paste it here and we will continue to next step which is create a rebuild/reorganise statement and executing it.

This site works from voting. Please click on the thumbs up for all helpful answers below. If any one answer lead to a solution to your problem, click on the check mark next to that answer.