I did manage to play around the stored proc - proc_RebuildSelectedIndexes.

The first 2 module should not be altered because there are perfect.

I crated my own Table

CREATE TABLE [dbo].[tblIndexFrag](

[SNO] [bigint]...

Wchaster; please just do this:

(select cast(reserved as float)*8192/(1024) move 8192 & the * sign out of the bracket. It will work withoiut changing precedence because the signs are of...

the issue is here:

FROM sys.dm_db_index_physical_stats(@dbid, @objectid,@index_id, NULL , 'Limited')

Parameter @index_id is really a nightmare. I am just trying to check on the parameters sent by the...

Hi ;

On Rebuilding Indexes on Stored Procedure proc_RebuildSelectedIndexes

on this line: SELECT IDENTITY(int,1,1) AS Sno

I get the following error: Parameter 3 is incorrect for this statement....

jbuttery, you are right but this is an issue where we assume everyone is using Enterprise Edition and again your server is always up. I am talking about a LIVE...

Peter;

Cool.... This is a complete thing. It doesn't mean the original scripts were wrong, there were very fantastic only some typo errors. But we know that sometimes we can not...

Procedure proc_FilltblUnusedIndexes (Manage Indexes)

Please check that table tblIndexUsageInfo does not have a field by the name IndexSelectionCrieteria

which you used on the UNION. If it is not a mistake...