Viewing 15 posts - 14,971 through 14,985 (of 59,101 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 30, 2017 at 8:20 am
That's a great idea, Eirikur. Simple and will have a major impact by probably reducing the amount of work that actually needs to be done to hundreds instead of tens of...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 29, 2017 at 7:44 am
There's only one term that comes to mind after all the incredible tutelage I've received on this thread and what it has resulted in and that would be UNBELIEVABLE! --Jeff Moden Change is inevitable... Change for the better is not.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
May 28, 2017 at 4:24 pm
Going for the brass ring... here's a progress report.
The following code does the "temp table" optimization that Eirikur suggested. It examined 84,817 execution plans, eliminated about 6% of...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2017 at 3:10 pm
F
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2017 at 12:14 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2017 at 9:59 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2017 at 11:17 am
OMG. You folks are going to actually make me smart about XML. Eirikur, that's more in the direction of where Johan was going and that's awesome. Thanks for the demo. --Jeff Moden Change is inevitable... Change for the better is not.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
May 27, 2017 at 9:46 am
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 11:43 am
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 11:36 am
Heh... I absolutely agree that learning new things is essential in this industry. For many of the DBAs and Developers that I've interviewed over the last decade, I would suggest...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 11:23 am
BWAAAA-HAAAA!!!! Too funny! I just saw Mark's tagline in his signature line.
Deja View - The strange feeling that somewhere, sometime you've optimised this query before.
I'm thinking...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 11:12 am
Studying Mark's good solution for this, the code has an interesting parallel in T-SQL known as the "CROSSTAB".
Just a bit of a followup to help those that...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 10:49 am
I only came to this starting point:
Select PlanXML.xmlnode.value('@FieldName',...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 7:42 am
This should give you what you want
WITH XMLNAMESPACES ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' as p)
SELECT...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 26, 2017 at 7:35 am
Viewing 15 posts - 14,971 through 14,985 (of 59,101 total)