Browse by Tags

• analysis
• best practice
• dbcc
• defrag
• duplicate
• fragmentation
• Hardware
• kba
• key
• log
• objectname
• performance
• rebuild
• security
• showcontig
• SQL Server
• table
• tempdb
• update statistics

• Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

  This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. Read More... Posted Friday, August 24, 2007 9:24 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, fragmentation, table, dbcc, index, showcontig, defrag

• Update statistics causing negative performance

  Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics Read More... Posted Saturday, August 18, 2007 11:11 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, update statistics, fragmentation, index, tempdb, log, best practice

• FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you try to update the index key columns of a non-unique clustered Read More... Posted Wednesday, August 15, 2007 8:28 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, index, objectname, duplicate, key

• DMVs to provide state of TEMPDB during a performance tuning analysis

  TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up. Though Read More... Posted Tuesday, August 14, 2007 11:55 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, analysis, rebuild, index, tempdb