Browse by Tags

SQL Server 2005 detect DAC session with TSQL

Published 9 May 8 1:11 PM | SSQA.net

SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important...

Filed under: sql server, security, dmv, tsql, dac, session

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics