Mixing Data Types in JOIN or WHERE Clauses.Using a Non-SARGable Expression in a WHERE Clause.Not Using Semicolon to Terminate Statements.Using the NOT IN Predicate in the WHERE Clause.Using ‘= NULL’ or ‘ NULL’ to Filter a Nullable Column.Nullable Columns with No Non-Null Records. It must not rely on deprecated features of SQL Server or assume specific database settings. It must be readable, well laid out and it must be robust and resilient. T-SQL code must execute properly and performant.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |