Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.
SQL SERVER – SQL Server Management Studio and Client Statistics
Query cost does not tell you how much data a query returns. Client statistics in SQL Server Management Studio do, and there are three ways to turn them on.
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.
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
Reader Bob explains why aggregate concatenation results depend on expression location, using an ANSI point of view, and shares a similar example to run.
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.
Finding the Real Error Behind an SSMS Dialog
Finding the real error behind an SSMS dialog starts with technical details, inner exceptions, and a safe query-window reproduction.