Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Database Engine

Trace Flag 9059 gone in SQL Server 2005

Does anyone know if the behavior in SP4 which was disabled with the Trace Flag of 9059, has been made permanent in Sql 2005?

We have a vendor app. that required us to turn on TF9059 after upgrading to SP4, so we are wondering, since TF is not in any Sql2005 doc, if moving the app to Sql2005 will cause the same performance issue the app had in SP4 when the TF9059 was not enabled.

thanks

[415 byte] By [pg1024] at [2007-12-25]
«« Question about new DataGridView control
»» Missing <RequestType> element in an RST generated by Cardspace CTP September 2006
# 1
tf9059 (as described in kb 899976) forces the system to convert from a higher precision or scale to a lower precision or scale to do an index seek. Having it turned on by default is definitely not desired in normal operation. So, as with sp4, sql2k5 has this turned off.
oj at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2

oj,

thanks for responding but maybe I wasn't specific enough. does tf9059 exist in sql2k5? I don't see it listed in the trace flag portion of the documentation.

pg1024 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 3
I can't confirm the existence of it. However, traceflag 9059 has no effect in sql2k5 anymore. You _cannot_ force the engine to down convert and return incorrect result in sql2k5.
oj at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 4
The traceflag does not exist in SQL 2005. -- Peter Byrne Microsoft SQL Server Storage Engine This posting is provided "AS IS" with no warranties, and confers no rights. wrote in message news:deaafb26-cd84-4c32-9097-29d0415a1f73@discussions.microsoft.com... >I can't confirm the existence of it. However, traceflag 9059 has no
> effect in sql2k5 anymore. You _cannot_ force the engine to down convert
> and return incorrect result in sql2k5. >
>
MVPUser at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
SQL Server
SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified