hey mate

what's authority

rules were made so you know what you are breaking

and you are only breaking them "only" when you get caught

man had i known ...

I would have done a dump in it as well

too many....

the problem is that I inherited these from someone else who assured me that problematic table was fine. I did not assume anything was wrong with it little did...

Hi,

i worked out what my problem is!!!!

it wasnt my temp table apparently the index on that runs quite fast. The problem was when I hooked it into the chart of...

Hi,

correct me if i am wrong here but what you are suggesting is that I aggregate that temp table I have and dump it into a #temp table before joining...

hi,

the function I am using does something like this

http://www.sqlservercentral.com/scripts/Miscellaneous/31913/

actually it was copied from this site. How can I put an index against this table then to prevent the...

Hi Chris,

thanks for your code. Where does this tally table come into play? My variables for the delimiters come in from a drop down box which comes from reporting services.

Thanks

Hi Gail,

thanks for the post. Does that apply to me because in your post the NCI and CI must point to the same table with a nested join which does...

Hi David,

just a quick question and forgive me if it sounds stupid. But I would like to know how did you know the 28% was a key look up. To...

ok will take what has been said and will apply thanks for the help.

Hi,

but the table scan uses very little resources.

Thanks for the replies.

One thing I would like to clarify is if in an execution plan the only items that have percentages are clustered index seeks and index seeks...

H,

thanks for the numerous responses. On the temp table besides the identity pk column being a candidate for the clustered index could you tell me what other column(s) would be...

Hi,

I tried to run my code with the multi column index and the result has not been all that great. What I then did was take a subset of the...

Hi,

thanks for the quick reply. Initially I did use a single column clustered index which was based on my identity ok field (this acts as a surrogate key) and then...