SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2011

SQL Server 2011 “Denali”: Four new useful DMV

SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them were already introduced in SP1 of SQL Server 2008 R2 but it was only two month ago (July 2011). I believe that these views were developed in new release… Read more

0 comments, 682 reads

Posted in SQL Treeo on 14 September 2011

SQL Server DMV Views: Getting slow queries within stored procedure

SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and you find out that it’s slow. It would be nice if you could discover which single query/ies in your procedures causes that it is slow. Few DMV… Read more

0 comments, 1,237 reads

Posted in SQL Treeo on 8 September 2011

SQL Server 2011 “Denali”: Give feedback and win nice gifts

Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for 30$. All you have to do is to report a bug or make a suggestion till September 10, 2011 and be in 300 of first.

Please follow instructions in this… Read more

0 comments, 591 reads

Posted in SQL Treeo on 5 September 2011