Viewing 15 posts - 1 through 15 (of 24 total)
@vincentshanecurtis - You asked a question and Gail responded within half an hour offering help (over 15 years of SQL Server experience have taught me she's high on...
September 1, 2017 at 9:55 am
Just a few more points:
A company wide policy should be in place for how SQL objects are worked on rather than...
June 19, 2015 at 1:45 am
First of all marwa, congratulations on sticking your head over the parapet and being brave enough to post an article on SQL Server Central; sharing knowledge is how people learn.
June 18, 2015 at 8:03 am
Also can't find the SQL.
In the absence of this I'm trying to understand the silhouetting explanation. How is the result in the range -1 to 1? Are the distances...
April 16, 2015 at 5:20 am
Alan B. - Welcome to the discussion. Things have moved on while I've been sleeping in the UK 🙂 Just to point out that in my case the CTEs were...
March 19, 2015 at 2:52 am
Out of interest were you able to get an estimated execution plan?
March 18, 2015 at 11:05 am
That is strange. As Old Hand mentioned re-writing to use sub-queries that filter should produced the same execution plan for simple CTEs.
I would also flag up that using query hints...
March 18, 2015 at 11:01 am
Ben and jhood,
I fell foul of too many articles along the lines of "Look at CTEs, they're fantastic" which never mentioned possible performance issues. That was the reason I posted...
March 18, 2015 at 9:16 am
My experience was also in a BI system. Where two updates based on recursive CTEs took over 20 mins, using a temp table reduced it to 15 seconds.
The code was...
March 18, 2015 at 6:27 am
Just worth pointing out that CTEs against large tables can be very slow; something I have had first hand experience of.
Here is an alternative method that proved much more performant...
March 18, 2015 at 2:55 am
Andrew Watson-478275 (3/7/2014)
I think that the Disc World novels lose too much in any unwritten form. Some of the descriptions make it what it is.
TV, I'd agree; however I've just...
March 7, 2014 at 3:54 am
I first read it when I was about 12 and it didn't seem that bad (I'm a bit older now:Whistling:) - maybe I need to blow the dust off the...
March 7, 2014 at 2:40 am
Jennifer Levy (3/5/2014)
And (I know there has been talk about this for years, but...) they REALLY need to do Good Omens by Terry Pratchett and Neil Gaiman. But only...
March 7, 2014 at 2:15 am
Can't believe Eddings is/are getting so many mentions, but no one has put forward Feist.
March 3, 2014 at 1:54 am
Gazareth (2/28/2014)I always thought David Eddings' Elenium and Tamuli series would make cracking films.
The Belgariad and Malloreon by Eddings would also make a good film series I think. I...
February 28, 2014 at 5:22 am