It's been a while, so here's a few more:

Trace Flag: 9481

Purpose: Use when running SQL Server 2014 with the default database compatibility level 120. Trace flag 9481 forces the query...

Nice article, but a better test would have been to create ten databases, each with slightly different data. I suspect the dedupe ratio would be drastically reduced for the...

This is not the thread to ask these questions.

Find the message number in [font="Courier New"]master..sysmessages[/font] and then use [font="Courier New"]sp_altermessage[/font] as appropriate.

Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option

Trace Flag: 2549

Purpose: Parallel CHECKDB operations when using mount points

KB Article: http://support.microsoft.com/kb/2634571

First...

New 4199 Fixes:

KB2276330: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2

KB2698639: Performance of a SELECT statement that contains a LIKE operator and an...

Trace Flag: 2470

Purpose: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012

KB Article: http://support.microsoft.com/kb/2606883

First Added: ...

Trace Flag: 1140

Purpose: Continuous tempdb growth after upgrading SQL 2005 pre-SP2 to SP3/SP4 or to SQL 2008 or newer

KB Article: http://support.microsoft.com/kb/2000471

First Added: SQL 2005 SP2 build 3166

Versions:...

Trace Flag: 7608

Purpose: Performance fix for slow full text population with a composite clustered index

KB Article: http://support.microsoft.com/kb/938672

First Added: SQL 2005 SP2 CU3

Versions: SQL 2005, SQL 2008,...

A quick query shows a lot of trace flags just for SQL 2005 that are not listed.

http://support.microsoft.com/search/default.aspx?mode=a&query=trace+flag&spid=2855&catalog=LCID%3D1033&1033comm=1&ast=28&res=100

It would be nice if Microsoft were to publish a document in...

Trace flag 4618 for SQL 2005

http://support.microsoft.com/kb/933564

FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005

Apply trace flag 4618 to limit the number of...

Trace flag 8030 for SQL 2005

http://support.microsoft.com/kb/917035

FIX: Query performance may decrease after SQL Server 2005 has been running for a while

Symptoms

Consider the following scenario. A server has been running for a...

I submitted a script that will export/import a SQL EM configuration, including a group hierarchy up to 5 levels deep.

It is posted here: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1795

What is the default database for the account? If it is anything but master, try changing it to master, apply the change, then switch it back to the user...

If this is a named instance, then the instance could be using a dynamic port number. If you have to access the instance through a firewall, then you will...

Enable remote connections in the Configuration Tools\SQL Server Surface Area Configuration utility.