Viewing 15 posts - 1,996 through 2,010 (of 8,416 total)
Oliiii (5/6/2011)
May 6, 2011 at 9:12 am
mark hutchinson (5/5/2011)
Does the stringbuilder class also suffer from the same performance 'hit' as the string object? (in this usage context)
Well not exactly in the current context (StringBuilder builds strings,...
May 5, 2011 at 5:51 pm
It's all about type conversions. You can find the data type precedence rules here:
http://msdn.microsoft.com/en-us/library/ms190309.aspx
An extract:
When an operator combines two expressions of different data types, the rules for data type...
May 5, 2011 at 5:36 pm
The remote transaction promotion technique is described in more detail here:
I used the same trick with sequence tables:
http://sqlblog.com/blogs/paul_white/archive/2010/10/19/sequence-tables.aspx
But it's hard to recommend this technique (it's quite slow, and there are...
May 5, 2011 at 5:23 pm
duncfair (5/5/2011)
when datediff(d, datecolumn, getdate()) between 0 and 7 then 1
when datediff(d, datecolumn, getdate()) between 8...
May 5, 2011 at 5:10 pm
Either of the two approaches listed so far will work: there is frequently more than one way to perform any given task in SQL (but see the examples below).
The reason...
May 5, 2011 at 4:22 pm
Jeff Moden (5/4/2011)
SQLkiwi (5/4/2011)
This is the CLR code I wrote for Jeff.
Thanks for stopping by, Paul. Now I don't have to send you an email to ask you to...
May 4, 2011 at 2:34 pm
mark hutchinson (5/4/2011)
SQLkiwiIs there a reason you didn't use the Split() method for C# strings?
http://msdn.microsoft.com/en-us/library/ms228388(v=vs.80).aspx
Yes: memory usage, and speed.
Split is relatively slow because it creates a whole bunch of new...
May 4, 2011 at 5:57 am
This is the CLR code I wrote for Jeff. It's not flash, but it is simple, fast, and handles strings of any length, Unicode or not.
There are three implementations...
May 4, 2011 at 3:58 am
Jack Corbett (5/3/2011)
Hey Mr. SQLKiwi,Have you submitted any sessions for the Summit? Your optimizer session would be a great addition to the schedule (hint, hint).:-D
Well. Adam Machanic had...
May 4, 2011 at 1:20 am
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Well done. It was a very good presentation.
May 2, 2011 at 9:57 pm
Ninja's_RGR'us (5/2/2011)
You can always mail it to me if you want... I won't tell a soul :-).
No, I am resisting casting further aspertions on Craig's mental health.
Ninja's_RGR'us (5/2/2011)
May 2, 2011 at 11:01 am
GilaMonster (5/2/2011)
I'm only reporting if he crosses the line to insulting. Like this morning, when he called Craig "mentally retarted"
Must. Resist. Obvious. Response...
Gah!
May 2, 2011 at 10:53 am
[Jim].[dba].[Murphy] (4/29/2011)
Hey Paul - BTW, congrats on the MVP award! And I dig the light little 'MVP' on your avatar/icon. Not very obvious, but still visible.
Thank you, Jim...
April 29, 2011 at 5:46 pm
Steve Jones - SSC Editor (4/29/2011)
...Don't like IE, haven't tried IE9, but if it's like Chrome, why move?
Because Chrome isn't perfect either 😉
SSC was particularly bad with Chrome for a...
April 29, 2011 at 5:39 pm
Viewing 15 posts - 1,996 through 2,010 (of 8,416 total)