Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2009

Be Careful with String Concatenations in SQL Server with Big Strings.

 Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase in a linear fashion with increasing size of a string. For a short string, it was blindingly fast, but when you scale up, the performance gets disappointing. When you're handling… Read more

22 comments, 2,932 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 16 February 2009

Inserting Markup into a String with SQL

 There are a number of occasions when one might want to insert information at various places in a string. Where one has a template for reporting or emailing, for example; or maybe creating an HTML-formatted result.  Here is a method that I've used a fair amount, and which I'm refining… Read more

6 comments, 651 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 12 February 2009