100 Things I Hate About Views: Undeclared Data Types in Columns
Category:
database-administration
, sql-server
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
Tag: data-types
AVG() in TSQL: Watch Your Data Types
Category:
tsql-programming
, sql-server
This week’s Quizletter featured a quiz on using the AVG() function in SQL Server.
I was inspired to write this quiz because I’ve been teaching “TSQL School” each week. When we covered aggregate functions, I remembered how tricksy AVG() can be.
Data Type Mismatches Do Not Always Cause a Bad Implicit Conversion and Index Scan
Category:
query-performance
Here’s a great recent question that I got about query tuning and index use:
Assuming that the documented levels of data type precedence in SQL Server are true as of SQL 2016, why does a bigint value not force an index scan when compared against an int column?