Well it is a monthly item, however we have some space concerns, my DBA says that creating slices of this table will be counter productive because he has partitioned the...

I am not certain what that entails, I am not a DBA, but a lowly dev.

Again thank you. I really can't post the SQL Due to confidentiality issues, and reworking it to be annonymous would be time consuming. I do appreciate the fact that Tuning...

Thanks for the Response.

I was reading that perhaps creating a UDF (User Defined Function) to process the String would be faster, or perhaps a CLR assembly? Does anyone have an...