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?
SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query
A query on the base table used an index it did not own. It was the index on index view of the same table, an interesting observation from an optimization project.
SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function
How do you insert values of stored procedure output into a table? The traditional temp table way, and an alternate method with a Table Valued Function.
Integer Division: Keep Quotient and Remainder Together
Integer division and modulo can reconstruct the original signed dividend. These read-only cases keep both operands, quotient, remainder and reconstructed value together.
SQL SERVER – Introduction to Service Broker and Sample Script
Here is my introduction to Service Broker and sample script: messaging and queuing between instances, conversations and dialogs in SQL Server 2005.
SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
Aggregate concatenation queries can return different results depending on where the expression sits. A simple script based on a note I found on Ward Pond’s blog.