I've often come across indexes that have been created in ignorance e.g. Col1, Col2, Col3 where the access (queries and/or reporting etc) were always select or join on Col1, ...Col2,...

Thanks for that - I know it's not index related but it was prompted by reading another contribution (summary/detail tables).

Jim

Hi Gail,

(I promise I'll give up soon) - Am I missing something (as some colleagues have already suggested).

If an identity column is used for the clustered index (CI) and NC...

Hi again,

Sadly we're still on SQL2000 so I'm reading these articles for interest (just starting to move stuff to SQL2005) however, one thing I've frequently come across that would be...

Hi,

Points taken - "hard to believe" (whole clustered index value in non clustered index) - I'm surprised that non clustered indexes don't also use the RID to provide a more...

Hi,

I find it difficult to believe this article, especially the reference that all non clustered indexes use the clustered index as their lowest level address (hence a large clustered index...

I tend to use standard rounding via a user function ROUNDIT(RawVal,DecPl,RoundVal) which uses a similar approach to the example:-

FIX(RawVal * 10^DecPl + (SGN(RawVal) * RoundVal))/ 10 ^ DecPl

where

RawVal is the...

Great - just what I was looking for however I found that the If statement had to all be keyed as a single line for it to work.

Strange really as...