Browse by Tags

Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.

Published 17 March 8 4:39 AM | SSQA.net

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...

Filed under: sql server, blocking, dmv, version, 2000, pack, 2005, tsql, errorr, tablels, incorrect syntax

SQL Server 2005: Slow running queries - Blocking and Index problems

Published 24 September 7 9:19 AM | SSQA.net

As a DBA you must be aware that slow or long running queries can contribute to excessive resource consumption and be the consequence of blocked queries. No database application is exception to this behaviour, so the queries that also run slowly because...

Filed under: sql server, indexes, blocking, dmv, blog, tsql, poor