Index seeks on date and CONVERT

Using functions on columns typically prevents SQL Server from being able to efficiently use an index with a seek (sargability).  When it comes to DATE and DATETIME data types, there are some exceptions. A common use case I see is where a column contains a DATETIME data type; however, a query needs to look at […]

Read More