yes I know its a star-schema, but its not for the purpose of a warehouse/cube solution. This is a day to day system and the only design change I...

im with u jeff that in db world you need to store everything at the lowest grain e.g. date, products etc. will make your dba life easier and the system...

wow!, using this tally approach for the same amount & type of records ran in ~10mins.

I included the qauntity field in an existing non-clustered index which should speed up things.

Would...

Looking at the results below for the include part of the index;

--with xml

table1255203 2627752 KB1294992 KB1332208 KB 552 KB

--without xml

table1255203 ...

The screen didnt let me add the xml column to the include part of the nonclustered index.

So I scripted it out then added it manually, this created the index.

Is this...

tablediff is installed only if you have the replication components installed.