Viewing 15 posts - 16 through 30 (of 8,414 total)
I do apologise for bringing "farce" to this discussion :pinch:. I know there are strong views on both sides about what is and isn't legal for the optimizer to do....
September 26, 2014 at 1:22 pm
It is not a bug (in SQL Server, the T-SQL code has a bug, of course).
There is always a temptation to read T-SQL as a sequence of steps, particularly where...
September 25, 2014 at 6:50 pm
sfrostx (9/25/2014)
Can anyone help me understand why the second and third selects in the following generate an error?
The optimizer is free to reorder expression evaluation. In the second and third...
September 25, 2014 at 4:55 pm
Steve Jones - SSC Editor (7/31/2014)
Maybe I should visit SO/SE more often 😀
The riff-raff filter has been playing up recently :w00t:
July 31, 2014 at 12:21 pm
The problem with SO is the sheer volume. With volume comes a drop in quality: of the questions asked, answers given, and (in my view) the average behaviour of the...
July 31, 2014 at 12:02 pm
Jeff Moden (6/25/2014)
June 27, 2014 at 12:46 am
Stefan Krzywicki (6/24/2014)
I know this is an old article reprinted and you might not see this, but I thought I'd ask anyway.
If you're using a Scalar UDF to define...
June 24, 2014 at 3:33 pm
Jeff Moden (5/15/2014)
May 15, 2014 at 9:39 pm
Solomon Rutzky (5/15/2014)
...it still might be interesting to test this theory of using a CLR-based number generator in the T-SQL splitters...
I agree, though one has to ask if you can...
May 15, 2014 at 2:22 pm
Eirikur Eiriksson (5/14/2014)
A thought, should we put together a data set for this purpose, at least we can eliminate one variable from the equation?
I have no objections. See what everyone...
May 14, 2014 at 1:30 pm
Is everyone running Jeff's original/updated test rig from the article to get these results?
If so, you might not be testing what you think you are. There is a weakness in...
May 14, 2014 at 12:46 pm
mburbea (5/13/2014)
May 13, 2014 at 2:27 pm
Ville-Pekka Vahteala (5/12/2014)
May 12, 2014 at 5:51 am
mister.magoo (5/9/2014)
mburbea (5/9/2014)
May 10, 2014 at 5:25 am
mburbea (5/8/2014)
That's what I figured. I hate scalar udfs in sql server as they tend to perform so poorly 🙁
Me too. I rarely (very rarely!) use them or recommend them,...
May 8, 2014 at 8:19 am
Viewing 15 posts - 16 through 30 (of 8,414 total)