Viewing 15 posts - 5,041 through 5,055 (of 10,144 total)
Eugene Elutin (3/14/2013)
ChrisM@Work (3/14/2013)
Eugene, that is absolutely spot on, and your last sole-user sample is an excellent demonstration of the distribution limitation. However, the sample sets provided by the OP...
March 14, 2013 at 4:53 am
Eugene Elutin (3/14/2013)
Mark-101232 (3/14/2013)
Eugene Elutin (3/14/2013)
March 14, 2013 at 4:01 am
Mark-101232 (3/14/2013)
Eugene Elutin (3/14/2013)
March 14, 2013 at 3:37 am
Eugene Elutin (3/13/2013)
Those logtimes look sequential to me - are you sure?
What do you mean by "sequential"? These LogTimes are for the same UserId, they are unique and they grow...
March 14, 2013 at 2:37 am
Steven Willis (3/13/2013)
DelimitedSplit8K is far from overkill. Why use a hammer when you have a nail gun?
+1 😉
March 14, 2013 at 1:39 am
Eugene Elutin (3/13/2013)
Try this one:
SET DATEFORMAT dmy;
CREATE TABLE #Source (LogIndex int, UserID nvarchar (10), LogTime datetime, Tipo smallint);
CREATE TABLE #Temp (LogIndex int,...
March 13, 2013 at 9:49 am
Eugene Elutin (3/13/2013)
ChrisM@Work (3/13/2013)
Eugene Elutin (3/13/2013)
Still running after 12 minutes.Some one around was looking for CPU killer query... I need to cancel that one!
Hahahaha!
I didn't say it would be...
March 13, 2013 at 9:24 am
Eugene Elutin (3/13/2013)
Still running after 12 minutes.Some one around was looking for CPU killer query... I need to cancel that one!
Hahahaha!
I didn't say it would be faster, but it...
March 13, 2013 at 8:44 am
Eugene Elutin (3/13/2013)
And it does look less code. But...
Cause it's based on recursive CTE and hidden triangular join (via cross apply), it's performance very unlikely...
March 13, 2013 at 7:20 am
Eugene Elutin (3/13/2013)
ChrisM@Work (3/13/2013)
Eugene Elutin (3/13/2013)
I'm sure you didn't mark rows to be "ok" for UserId 01552 correctly, please check carefully!
01552 is correct, 01551 is incorrect:
;WITH OrderedData AS (
SELECT *,...
March 13, 2013 at 6:04 am
Eugene Elutin (3/13/2013)
I'm sure you didn't mark rows to be "ok" for UserId 01552 correctly, please check carefully!
01552 is correct, 01551 is incorrect:
;WITH OrderedData AS (
SELECT *, seq = ROW_NUMBER()...
March 13, 2013 at 5:51 am
SELECT m.*, Amount = ISNULL(a.Amt,0)
FROM #MAster m
LEFT JOIN #Amount a
ON a.YoA = m.YoA AND a.Currency = m.Currency
ORDER BY m.YoA, m.Currency
March 13, 2013 at 2:37 am
AndrewSQLDBA (3/12/2013)
I was actually looking for something else. That really did not help.Andrew SQLDBA
What's the problem with it, Andrew? There is an alternative; I'm just curious.
March 12, 2013 at 9:38 am
TheSQLGuru (3/12/2013)
ChrisM@Work (3/12/2013)
TheSQLGuru (3/12/2013)
One minor point ChrisM - never do a SELECT INTO... with an ORDER BY. No benefit there.
Thanks for the reminder, Kevin. I wouldn't say "never" however,...
March 12, 2013 at 9:02 am
Siobhan Perricone (3/12/2013)
March 12, 2013 at 8:36 am
Viewing 15 posts - 5,041 through 5,055 (of 10,144 total)