Ever notice how IntelliSense in SSMS lists functions that don't work or aren't documented? Here's documentation for one that works: UNCOMPRESS
Tag: T-SQL
How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?
Does resetting an Identity Seed to a specific value via DBCC CHECKIDENT(..., RESEED, new_seed_value) work the way the documentation states? It depends 🙃
Beware! Beware of Unintended Changes When Altering Columns!
Beware of big green dragons, er, well, of unexpected changes when changing a column's datatype. You might be unpleasantly surprised! 🙀 Beware!
Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC)
Have you ever needed to prevent an entire script (or part of one) from executing? See how the session-level options PARSEONLY and NOEXEC can accomplish this.
Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?
An in-depth analysis of the new native UTF-8 support in SQL Server 2019.
Changing the Collation of the SQL Server Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
The investigation into valid T-SQL identifier characters continues. Apparently I was not done.
Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?
If you have ever used SET CONTEXT_INFO to store a simple value, you probably ran into this frustrating behavior 🙀
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
Come see the complete set of rules governing how you name things in SQL Server
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.