Alan,

In my experience, properly written C# is always going to be faster splitting large strings and parsing text than t-sql is. I know at one point I tested a...

Joe asked: "Can you give me example of something that has to be done with the CLR instead appear SQL?"

A while back I did a C# CLR function in SQL...

Or if the issue is that some system's incremental numbers started at 1 trillion plus 1, you could just subtract 1 trillion from the BIGINT form of your number 😀

I have been spending a lot of time on timezones and I'll share what we've been doing ...

First of all, everything I am doing is with the IANA timezones so...

OP,

I am just curious ... how do you know step 1 takes 10 minutes? Is there some way that you actually know that or is it an assumption based...

If you provided simple DDL and statements for sample data I bet you would be a lot more likely to get some help. I wouldn't mind showing you example...

Keep in mind that for cross apply with top (n) to outperform the use of ranking functions, you have to have an index available that is already sorting the data...

I'll be up front with you ... I read about 5% of what you wrote ... just too much to wade into.

One piece of advice ... if you are trying...

Eugene,

I've never had any issue with you whatsoever, but you seem condescendingly rude about some things I don't think you understand. That's not the kind of conversation I want...

Yes I did read it. Why CLR? Because it's awesome compiled code that will run very fast ... much faster than the equivalent in dynamic sql.

If he has...

Eugene Elutin (11/6/2012)

I don't think SEQUENCE feature will help you, as it's going to be a nightmare if you will create a sequence per customer... Also, you will be bound...

If you can get...

Use Google to find information on "sql server instead of trigger". I don't think anyone will write a trigger for you (especially given the lack of info you've supplied)...

So if you're selling products you have to design a...

What is the merge statement that you have tried to use and how is it not doing what you want it to do?