Viewing 15 posts - 7,411 through 7,425 (of 8,416 total)
Dave Ballantyne (7/21/2009)
Hi ho hi ho , if off to Disney i go , see you all in 4 weeks.Enjoyed my short time here, more rewarding than usenet anyway
Have...
July 21, 2009 at 5:28 pm
All good points Derek, but they have already been covered at least once in this thread (here for instance.)
July 21, 2009 at 5:22 pm
scziege (7/21/2009)
in a table of 130 Million rows and after that I have to create 100 Million
unique...
July 21, 2009 at 2:45 am
RBarryYoung (7/17/2009)
Paul White (7/17/2009)
jcrawf02 (7/17/2009)
That last one cracked me up. Kudos to your immense patience, and to David for that reply, wherever he may be.Your avatar seems to be broken...?
That's...
July 17, 2009 at 10:29 am
phlogiston (7/17/2009)
Given the differences between the execution plans submitted and the original query, you still provide fantastic advice. Thank you.
Very amusing Eric! :laugh: ...and thanks. It...
July 17, 2009 at 9:39 am
jcrawf02 (7/17/2009)
That last one cracked me up. Kudos to your immense patience, and to David for that reply, wherever he may be.
Your avatar seems to be broken...?
July 17, 2009 at 8:31 am
Hey Eric,
A few observations:
Using the ROW_NUMBER = 1 trick is a handy one, but the optimizer cannot use it to infer group-level uniqueness - the hash aggregate or sort distinct...
July 17, 2009 at 6:05 am
For those too lazy to look up CAST and CONVERT (in the truncating and rounding results section):
The integer value 34 is not converted to char(34), it is converted to '34'....
July 17, 2009 at 3:14 am
David.Poole (7/16/2009)
You wouldn't try and run your entire operation...
July 17, 2009 at 2:10 am
Kit G (7/15/2009)
My favorite Terry Prachett book is "The Fifth Elephant." Poor Vimes... my next favorite after that would be the book about Death.
Mort is my favourite, closely followed...
July 15, 2009 at 3:07 pm
David.Poole (7/15/2009)
Being able to split down onto standard or web edition offers massive cost savings.
But fewer features and potentially poorer performance.
David.Poole (7/15/2009)
Hardware is relatively cheap, M$ licensing isn't.
It is compared...
July 15, 2009 at 3:01 pm
Bruce W Cassidy (7/14/2009)
Paul White (7/14/2009)
July 14, 2009 at 5:35 pm
Grant Fritchey (7/14/2009)
July 14, 2009 at 4:11 pm
There are many better solutions, but in the interests of answering the question directly, the following 'works':
CREATE TABLE [dbo].[find_between](
[FromCode] sql_variant NOT NULL,
[ThruCode] sql_variant NOT NULL,
[Description] [varchar](30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
)...
July 14, 2009 at 4:13 am
Yep. Just couldn't be bothered...I'd gone to the trouble of wrapping it in and thought that would be good enough...seems not
July 14, 2009 at 3:52 am
Viewing 15 posts - 7,411 through 7,425 (of 8,416 total)