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.
SQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index
Community Tech Days comes to Ahmedabad on Oct 3, 2009, where I present The Other Side of Index: why a new index is not always the answer to a slow query.
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.
SQL SERVER – Outer Join in Indexed View – Question to Readers
Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?