sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,103 reads
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,103 reads
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...
2012-08-27
643 reads
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,327 reads
2012-07-20
2,595 reads
2012-07-11
3,277 reads
Find a string in any "string" (char, varchar, nchar etc) column in the database.
2012-05-22 (first published: 2007-12-19)
4,348 reads
2012-02-22
6,733 reads
What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?
2011-12-09
28,151 reads
2011-07-29
2,428 reads
2008-01-28
4,253 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
I am trying to use unpivot to extract some data, however, the results are...
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...