Viewing 15 posts - 6,541 through 6,555 (of 8,416 total)
TheSQLGuru (11/19/2009)
Isn't it nice of me that I let you come to that on your own instead of pointing out what a dodo you were?? 😀
Oh yes thanks so...
November 19, 2009 at 5:33 pm
Paul White (11/19/2009)
November 19, 2009 at 3:05 pm
Sucks to be you 😀
No, seriously, that's tough. Good luck eh.
November 19, 2009 at 2:13 pm
I just want to add, for the record, that if your files are 1MB or more on average, consider a 2008 upgrade for the FILESTREAM stuff. Otherwise, and especially...
November 19, 2009 at 2:10 pm
Alvin Ramard (11/19/2009)
Personally, I remember fondly a time when I was only of two minds. So do I and I and I and I and I...
[font="Courier New"]Msg 530, Level 16,...
November 19, 2009 at 2:06 pm
TheSQLGuru (11/19/2009)
I am not sure that blowing out a varchar(4000) conversion for lord knows what is a 'minor plan difference'!! 🙂
Ha, yeah. No, I just meant that the XML...
November 19, 2009 at 1:54 pm
Steve Jones - Editor (11/19/2009)
November 19, 2009 at 1:48 pm
TheSQLGuru (11/19/2009)
Paul, I seem to recall other topics from the years whereby BIN collation was the way to go for efficiency reasons if that was your most important criteria.
Oh absolutely...
November 19, 2009 at 1:40 pm
Great stuff 'C# screw' - awesome work on this thread 😎
November 19, 2009 at 1:31 pm
GSquared (11/19/2009)
Paul White (11/19/2009)
I'm in two minds about this:http://www.sqlservercentral.com/Forums/Topic821057-145-1.aspx#bm821538
Is it spam? Should I care? Thoughts?
It's spam. You should care.
You're probably right - it's just he/she is being...
November 19, 2009 at 7:04 am
jcrawf02 (11/19/2009)
Paul White (11/19/2009)
[...](which is also languages and culture sensitive!) [...]Awfully touchy-feelly stuff coming from a guy who exterminated the protectors of the galaxy in a fit of power-hungry revenge.
Hey...
November 19, 2009 at 7:00 am
A quick stand-alone repro for the collation thing:
USE tempdb;
GO
CREATE TABLE dbo.SpaceTest
(
Data VARCHAR(4000) NOT NULL
);
GO
INSERT dbo.SpaceTest
SELECT TOP...
November 19, 2009 at 6:58 am
I'm in two minds about this:
http://www.sqlservercentral.com/Forums/Topic821057-145-1.aspx#bm821538
Is it spam? Should I care? Thoughts?
Paul
November 19, 2009 at 6:52 am
Interesting. All the T-SQL methods (including Michael's) seem to suffer from the collation problem I described before. Running a 100K row test (using the script I posted before),...
November 19, 2009 at 6:06 am
Michael Meierruth (11/19/2009)
How did you make this calculation if the fastest T-SQL is 306 and the fastest CLR is 100?
Hmmm - I missed yours when I scanned down the results...
November 19, 2009 at 5:35 am
Viewing 15 posts - 6,541 through 6,555 (of 8,416 total)