Viewing 15 posts - 3,856 through 3,870 (of 8,415 total)
Stefan_G (4/14/2010)
Paul, I find your knowledge of the internal workings of SQL Server very impressive.How do you know all this internal stuff ?
Thanks very much, Stefan. For anyone interested...
April 14, 2010 at 2:01 am
karyn.webb (4/13/2010)
April 13, 2010 at 11:28 pm
Peter Trast (4/13/2010)
April 13, 2010 at 8:19 pm
Hugo Kornelis (4/13/2010)
"Assuming ANSI_NULLS are on in your SQL Server database, which they are by default..."Okay, I admit it - this snippet in the explanation is actually correct.
You'll be relieved...
April 13, 2010 at 5:40 pm
GabyYYZ (4/13/2010)
...but then the rational part of my brain kicks me in the groin...
Odd anatomical image :laugh:
April 13, 2010 at 5:21 pm
SQLDS (4/13/2010)
April 13, 2010 at 5:11 pm
Gianluca Sartori (4/13/2010)
April 13, 2010 at 5:08 pm
RBarryYoung (4/13/2010)
April 13, 2010 at 4:53 pm
korolana (4/13/2010)
From the performance point of view I don't think that calling UDTF on every row of...
April 13, 2010 at 4:15 pm
Hey Gianluca,
The answer is that it depends.
First, though, let me compare my results to yours.
Using HASH, I get 6s CPU and 26s elapsed.
Using MERGE, I get 1.5s CPU and 1.6s...
April 13, 2010 at 5:20 am
colgateway (4/12/2010)
...Then I downloaded your code and ran it. Same exact error.
The code you used doesn't quite match 'Query 08' in the download file - did you edit it?
The published...
April 12, 2010 at 7:19 pm
JJ B (4/12/2010)
April 12, 2010 at 4:49 pm
dbowlin (4/12/2010)
April 12, 2010 at 4:46 pm
WayneS (4/12/2010)
April 12, 2010 at 4:42 pm
Viewing 15 posts - 3,856 through 3,870 (of 8,415 total)