SQL Server 2005

All our SQL server related topics:

• regular expressions in sql server 2005 - http://msdn.microsoft.com/msdnmag/issues/07/02/SQLRegex/default.aspx
• performance issues with sql server 2005 - http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/perf/default.mspx?mfr=true
  • top 50 statements by average cpu time

    SELECT TOP 50
            qs.total_worker_time/qs.execution_count as [Avg CPU Time],
            SUBSTRING(qt.text,qs.statement_start_offset/2, 
    			(case when qs.statement_end_offset = -1 
    			then len(convert(nvarchar(max), qt.text)) * 2 
    			else qs.statement_end_offset end -qs.statement_start_offset)/2) 
    		as query_text,
    		qt.dbid, dbname=db_name(qt.dbid),
    		qt.objectid 
    FROM sys.dm_exec_query_stats qs
    cross apply sys.dm_exec_sql_text(qs.sql_handle) as qt
    ORDER BY 
            [Avg CPU Time] DESC
    
    

    • Adding Column After Another Column - SQL Server 2005
    • How To Enable SQL Full Text Indexing
      • IsFulltextEnabled
      • TheDatabase
      • TheDatabaseCatalog
    • Increasing Performance of SQL Server 2005
      • Increasing performance of Insert commands on a remote SQL Server 2005 database
        • FlushInsertQueryCache
        • InsertQuery
        • SqlCommand
        • The effect of buffers, flushes, and transactions, on insert operations with small data inserts to SQL Server 2005
    • NewSequentialID and GUIDs in SQL Server Databases
    • Repair Suspect Database On SQL Server 2005
    • SQL Server 2005 Full Text Indexing and Full Text Searching
    • SQL Server Express after database is attached, it says In Recovery
    • SQL Server Speed Test Performance Network Attached Storage Vs. External USB Hard Drive
    • Storage Best Practices