Its easy to check storage sizes for Tables and Indexes, you can right-click the table object on SSMS explorer and voila, the details appear in a nice popup. But since Indexed Views are displayed t...

can anybody tell me what are valid values for the flags parameter of the sp_MSdependencies stored procedure and especially what do they mean.

One of my developers working on a trigger-based logging facility in SQL Server 2008 asked me if there was a command to retrieve the most recently executed SQL command within T-SQL. I thought there ...