November 11, 2010 at 4:27 pm
Thanks Tim, it's good to see this important list is being updated
Cheers mate
Chris
--Chris Hamam
Life's a beach, then you DIE (Do It Eternally)
November 11, 2010 at 4:31 pm
Hopefully the author will update this list and resubmit it. If I have time, I'll try to add these as well.
November 11, 2010 at 4:38 pm
Hey thanks for the contribution guys, the web template does not auto imports so I'm manually inserting rows & copying them..... which is taking due time.
November 30, 2010 at 4:16 am
Updated list is online now, few of them appear to blank as I work on them.
Appreciate all the support, any errors or comments do let me know.
June 20, 2011 at 12:39 pm
How about Trace Flag 902 ? ANy info on this one besides its preventing scripts from running during start up such as those from a service pack update or similar update/install?
As of current I can't get connected to my SQL 2008 R2 instance unless I enable this because the thing gets stuck in the Script Upgrade mode because of a WIndows Security update gone bad. I'm waiting on MS SUpport to call back to fix however I was curious if anyone knows more about this flag such as whether or not is very bad to use it to gain temporary access to non-system DB's?
We have some key info in a SharePOint DB on this SQL Instance that we can't get at because if this problem. I was curious if anyone familiar with this flag knows if enabling it (temporally) so one can get at a non-system DB to get info only (read and no writes) is a definite no-no?
Thanks
Kindest Regards,
Just say No to Facebook!June 20, 2011 at 12:59 pm
At the moment I dont have much info about 902 except what I recall using it under SQL 2000 for Operating system error 5(Access is denied). Rest, let me check will update soon.
August 9, 2011 at 9:16 am
List updated.
August 9, 2011 at 9:25 am
yup (8/9/2011)
List updated.
Did the update have anything to do with Trace Flag 902 ? I did not see it in the list but I wanted to verify.
Kindest Regards,
Just say No to Facebook!August 9, 2011 at 9:31 am
Still working on that and few others.
902 is not in yet.
August 9, 2011 at 9:48 am
@yslguru did you got any reverts from MS? This was updated less than 50 days ago http://support.microsoft.com/kb/2163980), can you connect to me on yusufanis@msn.com
August 31, 2011 at 4:43 pm
I have not see this one yet. This one is to claims to solve memory pressure on 32 bit systems using the CLR.
Failed processing batch due to Thread was being aborted.
Article ID: 969962 - Last Review: June 18, 2010 - Revision: 2.0
Various memory errors are logged to SQL Server error log when using SQL CLR objects
http://support.microsoft.com/kb/969962
"giving more memory to SQL CLR by increasing the 'MemToLeave' or 'Non buffer pool memory' to 384 MB. This can be done by adding the -g384 switch to the startup parameters "
I also don't understand why they say use -g instead of -T which is what I normally would use.
November 28, 2011 at 1:40 pm
Trace Flag 8017 upgrade version conflict http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/dd6fdc16-9d8d-4186-9549-85ba4c322d10
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 29, 2011 at 2:12 am
Thanks ALZDBA this is currently marked with space in my list here, will soon update.
January 29, 2012 at 8:01 pm
Any one needed this after CTP3 of 2012 ?
tf 9532 to get more than 1 availability group replica in CTP3 Scope Startup.
July 5, 2012 at 12:13 pm
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, SQL 2008 R2, SQL 2012
Viewing 15 posts - 31 through 45 (of 69 total)
You must be logged in to reply to this topic. Login to reply