Viewing 15 posts - 14,971 through 14,985 (of 59,097 total)
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
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2017 at 11:38 am
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2017 at 11:07 am
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2017 at 9:02 am
Gosh... this article started out good with code that you could copy'n'paste to setup the test table. Why didn't you continue that with the remaining code examples instead of using...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2017 at 8:55 am
Viewing 15 posts - 14,971 through 14,985 (of 59,097 total)