Viewing 15 posts - 1 through 15 (of 533 total)
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...
September 15, 2016 at 3:43 pm
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...
September 15, 2016 at 1:48 pm
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 😀
August 27, 2016 at 11:13 pm
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...
August 25, 2016 at 11:35 pm
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...
November 1, 2013 at 1:42 pm
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...
December 17, 2012 at 11:04 am
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...
December 17, 2012 at 10:59 am
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...
November 9, 2012 at 10:52 am
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...
November 9, 2012 at 10:47 am
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...
November 8, 2012 at 4:11 pm
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...
November 8, 2012 at 2:38 pm
Ryan Keast (11/1/2012)
I prefer to go the SSIS route really.What would I need - just the actual driver installed on the SQL server of the Progress DB?
If you can get...
November 8, 2012 at 12:29 pm
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)...
November 8, 2012 at 12:04 pm
TheSQLGuru (10/4/2012)
2) Having a table per object type sold is unworkable - how many different types of objects does Amazon sell??
So if you're selling products you have to design a...
October 4, 2012 at 10:57 am
What is the merge statement that you have tried to use and how is it not doing what you want it to do?
October 3, 2012 at 6:17 pm
Viewing 15 posts - 1 through 15 (of 533 total)