Viewing 15 posts - 55,051 through 55,065 (of 59,067 total)
Duplicate records DO happen on staging tables used for preprocessing rows from third parties, especially telephone companies... Either a "UNIQUE WITH IGNORE DUPES" index must be used (comparitively very slow)...
September 12, 2007 at 4:16 pm
Heh... you're right... wrong article... it was about "RAAS", not "RAC"...
You'r still nothing more than a spammer... I can't understand why you don't get your product evaluated on this site......
September 12, 2007 at 4:12 pm
This should do it nicely... classic cross-tab... you might be able to use SQL Server 2005 PIVOT as well... either way, it'll solve your slowdown because each row is only...
September 12, 2007 at 8:33 am
Also, be aware that this method uses a "Triangular Join" which can get very slow if the "triangles" are allowed to get to any size... they can be hundreds of times...
September 12, 2007 at 8:11 am
So, why not post how to make a "Numbers" table or provide the actual link? Aren't we a full service shop? ![]()
Venkat... here's how...
September 12, 2007 at 8:05 am
Karthik,
I get it from your description... Can't work on it right now because I'm on the way to work, but I've got to ask...
Why doesn't "he" want these flattened out...
September 12, 2007 at 8:01 am
The article was nice and simple... shows how to make and exec a proc that uses a table parameter.
What I'd like to know (and anyone can certainly answer) is why...
September 12, 2007 at 7:44 am
Heh... more spam... at least the table example works, Rog... Saw the free code you guys posted for RAC and apparently a lot of the stuff doesn't work correctly...
September 12, 2007 at 7:39 am
On a busy system, if it's a batch proc, wait 5 minutes after it's done, and it won't be cached any more.
On a busy system, if it's a GUI proc,...
September 11, 2007 at 11:00 pm
Somebody,
If I have a lot of candidates with good resumes all lined up, I'll ask some questions outside of what the job specifically requires as "tie-breakers".
For example... let's say I...
September 11, 2007 at 10:44 pm
Subtracting 2 milliseconds from the date won't do it because dates have a 3.3 millisecond resolution.
And, instead of fooling around with the time for end date, why don't you...
September 11, 2007 at 9:09 pm
There is no time such as 24:00:00.000 because that would represent the next day ![]()
September 11, 2007 at 9:02 pm
Viewing 15 posts - 55,051 through 55,065 (of 59,067 total)