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, 1,784 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, 474 reads
Posted in Phil Factor's Phrenetic Phoughts: The SQL on 12 February 2009



Subscribe to this blog