<div>
its mentioned here <br />
<br />
<a href="http://support.microsoft.com/kb/960770" rel="ugc">http://support.microsoft.com/kb/960770</a>
</div>


its mentioned here

http://support.microsoft.com/kb/960770 [http://support.microsoft.com/kb/960770]

<div>
Take a look here:<br />
<br />
<a href="http://www.straightpathsql.com/archives/2010/07/linked-server-query-running-slow/" rel="ugc">http://www.straightpathsql.com/archives/2010/07/linked-server-query-running-slow/</a><br />
<br />
Mike
</div>


Take a look here:

http://www.straightpathsql.com/archives/2010/07/linked-server-query-running-slow/ [http://www.straightpathsql.com/archives/2010/07/linked-server-query-running-slow/]

Mike

<div>
Mike, I didnt see anything about the trace flag.. What is it used for and how do you use it?
</div>


Mike, I didnt see anything about the trace flag.. What is it used for and how do you use it?

<div>
<div class="content wysiwyg-content">
Does anyone have any information on what the following does?<br />
<br />
This task has 8 steps.<br />
&nbsp;<br />
1. &nbsp; &nbsp;Open SQL Server Configuration Manager.<br />
2. &nbsp; &nbsp;From the list of services, select the SQL Server instance.<br />
3. &nbsp; &nbsp;Right-click and select Properties.<br />
4. &nbsp; &nbsp;Click the Advanced tab.<br />
&nbsp; 5. &nbsp; &nbsp;Click the Properties for Startup Parameters and append ;-T4135 to the existing parameters string.
</div>
</div>


Does anyone have any information on what the following does?

This task has 8 steps.
 
1.    Open SQL Server Configuration Manager.
2.    From the list of services, select the SQL Server instance.
3.    Right-click and select Properties.
4.    Click the Advanced tab.
  5.    Click the Properties for Startup Parameters and append ;-T4135 to the existing parameters string.

sql Trace Flag T4135

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.