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.
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?
Connecting Excel to SQL Server Safely
Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.
sp_refreshsqlmodule: Refreshing Views and Procedures After a Table Change
Use sp_refreshsqlmodule to refresh changed table dependencies, inspect stale view columns, and protect stable contracts with schema binding.
SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
Need to display code of a stored procedure, trigger, view or function? The system stored procedure sp_helptext prints the text of any unencrypted object.
SQL SERVER – Restrictions of Views – T SQL View Limitations
SQL Server views come with many rules, like ANSI_NULLS and QUOTED_IDENTIFIER being on. My list of view limitations, corrected with help from Ben Taylor.