Category: Development
SQL Server, T-SQL, and database development
- Deep Dive
When a VARCHAR Isn't a VARCHAR
Implicit conversions in T-SQL are silent and legal, and they can turn an index seek into a full table scan without any obvious cause.
- Deep Dive
Your SQL Server Version Isn't the Whole Story
Database compatibility level controls a lot more than most people realise, and it doesn't follow the SQL Server version automatically.
- Deep Dive
NOLOCK Isn't Free
NOLOCK is one of the most misused hints in T-SQL. Here's what it actually does, what it risks, and when it might be worth it.