Viewing 15 posts - 43,561 through 43,575 (of 59,063 total)
Gianluca Sartori (6/5/2009)
Jeff Moden (6/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2009 at 7:33 am
You actually store dates like 1/12/2009 in that format in a calendar table? What do you use those for? I'm asking because I'm curious. I've never seen...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 10:19 pm
Bruce W Cassidy (6/4/2009)
Jeff Moden (6/4/2009)
[...]don't store formatted dates in a table... not even a reporting table.
[font="Verdana"]We could have an argument about that, but in general I believe you are...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 9:00 pm
To add to what Luke has already stated, do a simple but powerful test that will prove that storing the formatted date in the table is absolutely the wrong thing...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 8:22 pm
Datamama (6/4/2009)
... and btw - every great DBA I have ever worked with sounds just like you.Josie
Heh... thanks Josie :blush:. Every good one I've worked with sounds the same...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 7:49 pm
WayneS (6/4/2009)
Paul, I do believe that you found what was going on.Now, I searched the net for hours, and never found any of these articles. How did you do it?
I...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 7:21 pm
Paul White (6/4/2009)
Jeff Moden (6/4/2009)
Here's the reason why I use Index(0) instead of Index(1). From BOL:
Cheers Jeff - it was your motivation in including the hint I was after...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 6:11 pm
WayneS (6/4/2009)
Jeff Moden (6/3/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 6:09 pm
Oh shoot. I almost forgot. In the absence of all indexes on the Temp Table, the ordered CTE or an ordered Derived Table may appear to work just...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 6:05 pm
Paul White (6/4/2009)
The last time I tried this, the 'intermediate materialization' forced a sort as one would expect, but the QO inserted a later sort to ensure updates were performed...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 5:50 pm
Paul White (6/4/2009)
Jeff Moden (6/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 5:47 pm
WayneS (6/4/2009)
Jeff Moden (6/3/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 5:45 pm
Adam Machanic (6/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 5:42 pm
Alvin Ramard (6/4/2009)
Jeff Moden (6/4/2009)
You've never seen the love-of-my-life's checkbook, have you? 😛
Is she the one the Eagles wrote "Take it to the limit" for?
Heh... no. She's actually...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 1:05 pm
Adam Machanic (6/4/2009)
I assume you don't need to do this with more than 2 billion rows!
You've never seen the love-of-my-life's checkbook, have you? 😛
A bit more information here:
Cool... I'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2009 at 12:59 pm
Viewing 15 posts - 43,561 through 43,575 (of 59,063 total)