Viewing 15 posts - 34,156 through 34,170 (of 59,102 total)
Tom.Thomson (4/26/2011)
Anyway, I don't dare use my apabet soup here - I'm frightened of how Jeff might react.
You, good sir, have proven time and again that you deserve to list...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 28, 2011 at 7:54 am
hensong (4/27/2011)
Never mind, got it.....Once again Thanks for the response.
What did you end up doing, Glenn?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 27, 2011 at 9:23 pm
skcadavre (4/26/2011)
First, lets build some test data......
I wasted too much time making up some test-data since you didn't supply any.
Nah... you did good. It's never a waste of time...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 27, 2011 at 9:13 pm
@Vedran,
Great post and absolutely correct on all accounts. It's not often that I see people with only 68 points turning out such a nice, informative answer like you did....
--Jeff Moden
Change is inevitable... Change for the better is not.
April 27, 2011 at 8:56 pm
alan.berger (4/27/2011)
and let me know what you think? It's a comparison of execution plans for 4 ways to get the...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 27, 2011 at 5:46 pm
Thank you for the replies. I'm at work right now and I'll build some code for you tonight.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 26, 2011 at 9:44 am
I believe you're going to have to explain that one. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 26, 2011 at 6:44 am
Thinking about how to put this together for you and have just a few more questions.
What will be done with the 10,000 records per page that you speak of? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 26, 2011 at 6:27 am
How many rows are in the table now?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 10:27 pm
bitbucket-25253 (4/25/2011)
JeffSent to you via email, the latest test results for the 4K splitter test. Just letting you know here to draw your attention to your e-mail
Thanks, Ron....
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 10:12 pm
I know the guy that wrote that article! 😛
That particular article calculates the number of week days between two given dates and I don't recommend it for this particular problem.
However,...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 10:07 pm
Steve Jones - SSC Editor (4/25/2011)
Craig Farrell (4/25/2011)
Steve Jones - SSC Editor (4/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 9:17 pm
Alright... I'll just do like I normally do and test this type of thing on a million rows. Here's the code to make a million row test table like...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 9:12 pm
The query creates a couple of Triangular joins where one internal leg consists of 270 rows and the other consists of 135 rows. Please see the following article for...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 7:01 pm
Very cool. Glad I could help and thank you for the feedback!
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 3:30 pm
Viewing 15 posts - 34,156 through 34,170 (of 59,102 total)