Browse by Tags

TSQL to change collation of database, whats new in SQL 2008 then?

Published 12 March 8 1:24 PM | SSQA.net

Cross post from my BlogCasts site....( read more ) Read More...

Filed under: sql server, blog, table, tsql, collation, changes

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