I have been working through this article and have found very instructional and also useful. I have not noticed anyone having problems with proc_InsertMostUsedIndexes. I am stuck. Whenever I run it I get the following error:
Msg 512, Level 16, State 1, Procedure proc_InsertMostUsedIndexes, Line 12
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I am at a deadend so if anyone could give me any help it would be greatly appriciated.
Thanks in advance.;-)