Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567

SQL Server Trace Flags Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 7:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:51 PM
Points: 311, Visits: 1,079
Excellent!!!


Post #1445423
Posted Tuesday, April 23, 2013 12:16 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:09 PM
Points: 2,035, Visits: 1,655
Lots of errors on this list. For instance, 3604 is used for all kinds of output from undocumented DBCC commands. Be careful when playing with these.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #1445623
Posted Tuesday, April 23, 2013 1:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:45 PM
Points: 159, Visits: 173
Anybody have any experience with 3499, The few pages I've found on google say this is to change the default behavior of a mirror database. (The mirror would treat the transaction log more like the principal vice hardening every transaction.) Just curious if anyone is using this or has it working. I've tested but saw no change whatsoever. Wondering if this (undocumented) flag was quietly deprecated in a service pack.
Post #1445658
Posted Wednesday, May 29, 2013 12:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:13 PM
Points: 264, Visits: 822
Next update coming on 05 Jul 2013.
Post #1457588
Posted Friday, July 05, 2013 1:00 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 05, 2013 1:03 PM
Points: 352, Visits: 110
Nicely done!
Post #1470845
Posted Thursday, October 17, 2013 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 2, Visits: 66
Please add trace flag 8605, according to Paul White's blog: http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx

Thanks,
Jim
Post #1505696
Posted Thursday, October 17, 2013 7:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:13 PM
Points: 264, Visits: 822
Thanks I'll add it up in the next update.
Post #1505698
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse