Here in this T-sql tip I'am trying to compare the word "Hijacker" with two cases(line 3 and 4). Now they are in same when you compare the case (letter to letter), now you change the case of word "Hijacker" in either of the lines and run this SQL statements it will return different results. This […]
2002-01-05
665 reads
Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]
2001-12-18
823 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
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/...
Ask SSC