Viewing 13 posts - 31 through 43 (of 43 total)
Does the stringbuilder class also suffer from the same performance 'hit' as the string object? (in this usage context)
May 5, 2011 at 2:40 pm
Glad you liked it.
If any C# readers are looking for a versatile Split() function, look at the one in the Microsoft.VisualBasic namespace.
May 4, 2011 at 5:58 am
Is there a reason you didn't use the Split() method for C# strings?
May 4, 2011 at 5:37 am
Thanks. Then this is an environmental property of 'compiled' TSQL of which I was not aware.
May 3, 2011 at 9:06 am
Thank you for your patience. I must not be asking my question in the right way. Sorry. I'll try one last time.
There are two parts to the...
May 3, 2011 at 8:18 am
I think you already identified the basic code in your articles. Since you have a test bed for performance comparison, I thought you might have tested a loop to...
May 2, 2011 at 10:22 pm
Glad I brought a wide smile or laugh to your face/heart. But I was serious. I'm used to minimizing operations in the normal course of performance-tuning. If...
May 2, 2011 at 9:32 pm
Thanks for writing both articles. I still don't understand why you use the CharIndex() when you could use a cursor to iterate through the delimiter positions. I think...
May 2, 2011 at 10:09 am
DECLARE @SELECT varchar(100)
DECLARE @FROM varchar(100)
DECLARE @DynamicSQL1 varchar(8000)
DECLARE @DynamicSQL2 varchar(8000)
January 8, 2008 at 4:27 pm
This is an encryption of the password, not a hash. The term 'hash' connotes a one-way process.
December 19, 2005 at 10:03 pm
1. There is a redundant condition check in your example. Once we start building the WHERE clause, we've already passed the first check, which would have prevented our getting down...
December 15, 2005 at 10:48 pm
How about a .Net code example of the validation to which you allude (username character limits)?
It would been more helpful if you mentioned the use of .Net validators and gave...
September 21, 2005 at 7:17 am
Select Distinct ...
will cause the output to be displayed in ascending sequence. If the first column is numeric, you can multiply the returned column by -1 to cause the...
November 7, 2002 at 5:51 am