Sql Server : Perils of using (not equal to sign) in JOINs

Posted by Sqltimes
On September 20, 2014
0 Comments

Recently, during review of some T-SQL code, I ran into the usage of “not equal to (<>)” operator in one of the queries with LEFT OUTER JOIN. This is interesting, because the general perception of ‘not equal to’ is different from the way Sql Server processes it. Let’s take an example: Two tables, Table1 & […]

Posted by Sqltimes
On September 13, 2014
0 Comments

Quick one today: Starting Sql Server 2012, looks like there has been a change to restarting options with Sql Server when connected from remote SSMS (a.k.a. when connecting to a Sql Server instance on a lab/prod server using SSMS on your laptop). Looks like this is part of the new security features. In a typical […]

Posted by Sqltimes
On September 4, 2014
0 Comments

More often these days, there have been many conversations around the topic of handling unicode data and UTF-* type data in Sql Server. Some details are below: Basics ASCII means American Standard Code for Information Interchange – based on English alphabet As you can see above, ASCII is only for English Unicode is a standard […]

Sql Server : Perils of using (not equal to sign) in JOINs

Sql Server: In SSMS, start, stop and restart buttons are disabled, when using SSMS to connect to a remote instance.

Sql Server : Collation and Unicode vs UTF-8, UTF-16 and UTF-32