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...
2009-02-16
14,573 reads
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,573 reads
There are a number of occasions when one might want to insert information at various places in a string. Where...
2009-02-12
1,820 reads
I have been admonished in the past for the use of this code which makes as many
substitutions as you like...
2009-01-23
1,140 reads
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
659 reads
SQL Server and Sybase are geared up
to send information to applications over two distinct channels, the results in
one channel that...
2008-10-20
895 reads
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,073 reads
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,649 reads
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,730 reads
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,201 reads
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
I recently started full time learning of Amazon Web Services (AWS). I found that...
Hello All, I have recently joined a project, where main, core tables with millions...
Long time listener, first time caller. I have a problem that my usual bag...
evening All hoping someone can shed some light - I have a (originally) 2...
How many table hints can I include in a query?
See possible answers