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: views
Gotchas with Deferred Name Resolution in SQL Server: Stored Procedures, Synonyms, Views, and Functions
Have you ever tried to create an object in SQL Server, but it failed due to a missing table, column, or other dependency? If so, you’ve hit a case where SQL Server doesn’t offer ‘deferred name resolution’.
Altering an Indexed View in SQL Server Drops All Indexes
Category:
database-administration
, sql-server
I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views. This is covered in the product documentation, but it’s not something I would have expected.
