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 123»»»

Statistics - 3 Expand / Collapse
Author
Message
Posted Monday, October 08, 2012 8:46 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 5,472, Visits: 23,540
Comments posted to this topic are about the item Statistics - 3

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1370137
Posted Monday, October 08, 2012 10:52 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
Thanks Ron for this great question today as well. It required a little bit of reading before attempting it.
Happy that I got it correct in the end


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1370159
Posted Tuesday, October 09, 2012 12:18 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 12,208, Visits: 9,174
Thanks for another great question Ron.
I choose Yes as I thought it would be sad if there wasn't such an option




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1370177
Posted Tuesday, October 09, 2012 2:00 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 9:02 AM
Points: 114, Visits: 140

After extensive search of MSDN and BOL, I (incorrectly) came to the conclusion that the only way to change the frequency was by scheduling a job to update stats.

Some obscure traceflag does not strike me as a bone fide way of acheiving this. Hurrumph!

Aren't traceflags things left behind by the Microsoft developers for their own purposes, and shouldn't be relied upon.
Post #1370211
Posted Tuesday, October 09, 2012 2:51 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:18 AM
Points: 1,769, Visits: 2,800
Thanks, good question. Actually guessed at the answer (hoped the specific versions mentioned was a clue), but it's taught me something I didn't know!

It is interesting that it's been implemented as a trace flag rather than say through sp_configure.
Maybe it will make it there in a future version or SP.

Definitely a setting you only want to change if you know what you're doing!
Post #1370229
Posted Tuesday, October 09, 2012 3:58 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:40 AM
Points: 3,683, Visits: 4,818
That is very interesting.
This question really got the grey matter working, thanks, Ron


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1370271
Posted Tuesday, October 09, 2012 4:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 1,263, Visits: 2,302
Very informative Ron! Thanks


Sujeet Singh
Post #1370272
Posted Tuesday, October 09, 2012 5:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:19 AM
Points: 1,625, Visits: 2,035
Koen Verbeeck (10/9/2012)
Thanks for another great question Ron.
I choose Yes as I thought it would be sad if there wasn't such an option


Same here. I thought that it wouldn't be worth posting if there wasn't a solution. Thanks for the question Ron.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1370326
Posted Tuesday, October 09, 2012 6:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 5:25 AM
Points: 39, Visits: 31
Hmm... I sort of still think I´m right on this one (and that the answer is no). "Is there a method / setting that will alter the fixed rate of change threshold" I assumed to be no since there is no way to alter the fixed rate. You can however set sql server to instead use a dynamic rate but you can´t change it to another fixed rate such as 40%... Or have I misunderstood something?

Cheers!
Post #1370367
Posted Tuesday, October 09, 2012 7:03 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:40 AM
Points: 189, Visits: 120
A very good question. I learn something new..
Thanks Ron!!
Post #1370373
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse