Specifying a collation in WHERE clause predicates can result in scan operations, even when there is an underlying index. Can we coerce SQL into using Index Seeks?

Optimizing a table for analytics and maintenance proved trickier than I expected.

For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.