Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
A junior developer used the FORCE ORDER query hint without knowing what it does. Here is how it works and how much this one hint can change performance.
geography Point: Latitude Comes Before Longitude
geography Point uses latitude, longitude and SRID arguments. Its coordinate order differs from POINT text, so inspect both returned properties.
Filtered Indexes and Where They Help
Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.
ALLOW_PAGE_LOCKS OFF Stops REORGANIZE
ALLOW_PAGE_LOCKS OFF prevents a rowstore index from being reorganized. A controlled example shows the maintenance error, checks the index setting and verifies that enabling page locks allows REORGANIZE without changing the stored rows.
Giving Web Developers Safe Database Access
Give web developers safe database access with narrow roles and views, a reporting replica where useful, and audit that identifies real changes.
Storing Files in the Database or on Disk
Storing files in the database requires tradeoffs in transactions, backup size, and access; compare varbinary, FILESTREAM, FileTable, and paths.