SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc

In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many that you might never see / encounter quite a few of them. Part of the issue is that there are four locations to find these options and functions. The four locations are: Menu bar (i.e.… Continue reading SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc

SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar

Check out the (only) completely complete guide to this cool feature of SSMS (that's off by default), including how to configure the colors 🎨 !

No, Binary Collations are not Case-Sensitive

(last updated: 2019-06-03 @ 16:00 EST / 2019-06-03 @ 20:00 UTC ) Quite often people will use, or will recommend using, a binary Collation (one ending in "_BIN" or "_BIN2") when wanting to do a case-sensitive operation. While in many cases it appears to behave as expected, it is best to not use a binary… Continue reading No, Binary Collations are not Case-Sensitive

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

(last updated: 2019-11-10 @ 11:15 EST / 2019-11-10 @ 16:15 UTC ) You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them is a JOIN or WHERE predicate / condition, as doing so will invalidate indexes. While it is always best to have all datatypes… Continue reading Impact on Indexes When Mixing VARCHAR and NVARCHAR Types