Browse Blog Posts by Tags

All Tags » index (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 17 2009
Filed under: Filed under: sql server, transaction log, update, kba, index, maintenance, smo, clustering, tempdb, service pack, backups, collation, knowledgebase, fulltext, device, cumulative update, clustered index, maxdop
TSQL to find the name of unique index that refers full text index

Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the name of unique index that refers full text index SELECT OBJECT_NAME ( fti . object_id ) AS 'Table Name' , i . name AS 'Index Name'...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 3 2009
Filed under: Filed under: sql server, index, table, full-text, tsql, object_name
SQL Server 2005 methods to find table INDEX or Statistics age for better performance

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 9 2008
Filed under: Filed under: sql server, performance, query, index, process, agent, statistics, timeout, statiscs age
Considering Parallel plans and forcing plans for better performance

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 23 2007
Filed under: Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force
FIX: Error message when you try to delete some stored procedures concurrently in SQL Server 2005: “Temp table deferred drop doesn't scale for certain workloads”

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you try to delete...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Oct 7 2007
Filed under: Filed under: sql server, kba, index, concurrent, corrupted, workload, temp table
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 24 2007
Filed under: Filed under: sql server, performance, security, dbcc, index, table, fragmentation, 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 17 2007
Filed under: Filed under: sql server, performance, log, index, tempdb, best practice, update statistics, fragmentation
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Aug 14 2007
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Aug 14 2007
Filed under: Filed under: sql server, performance, analysis, index, rebuild, tempdb, hardware
FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise x64 Edition Notification Contents: New and Major Modifications FIX: A database is marked as suspect when you...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jul 8 2007
Filed under: Filed under: sql server, database, kba, index, suspect
FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 22 2007
Filed under: Filed under: sql server, dbcc, kba, transaction, index, dbreindex
Index Defregment Best Practice

Read More...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Tue, Mar 27 2007
Filed under: Filed under: microsoft, sql server, Best Practice Analyzer, Index, Defregment

Page 1 of 1 (12 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.