March 13, 2014 at 8:38 pm
Comments posted to this topic are about the item Updating Statistics
March 13, 2014 at 11:31 pm
Enjoyed the question, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 3:33 am
This was removed by the editor as SPAM
March 14, 2014 at 4:23 am
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
March 14, 2014 at 5:18 am
UPDATE STATISTICS + sp_updatestats = 2 statements!
๐
March 14, 2014 at 5:43 am
Good question, thanks. They may be different statements, but a single statement can accomplish any of them.
March 14, 2014 at 6:32 am
nice question. thanks for sharing
March 14, 2014 at 6:33 am
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent of the question, so I choose database level.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 14, 2014 at 6:47 am
Koen Verbeeck (3/14/2014)
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent of the question, so I choose database level.
Yup. Same here. :ermm:
March 14, 2014 at 6:59 am
OCTom (3/14/2014)
Koen Verbeeck (3/14/2014)
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent of the question, so I choose database level.
Yup. Same here. :ermm:
Arrrgggh.... me too. :crazy:
I have to stop answering these first thing in the morning. :ermm:
March 14, 2014 at 7:32 am
sestell1 (3/14/2014)
OCTom (3/14/2014)
Koen Verbeeck (3/14/2014)
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent of the question, so I choose database level.
Yup. Same here. :ermm:
Arrrgggh.... me too. :crazy:
I have to stop answering these first thing in the morning. :ermm:
Almost happened to me and then I second guessed myself. Thanks for the question Steve.
March 14, 2014 at 10:35 am
Well, it depends:
sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows.
That is, if the rowmodctr is too low, the statistics is not updated.
Anyway, if you experience problem with statistics, you should try to add the traceflags in SQL Server 2008R2 (sp2) or later:
2371, Changes the threashold for auto update stats for large tables
2389, Changes the behaviour of known incrementing columns like IDENTITY
2390, Changes the behaviour of columns with incrementing values like a datetime column with incrementing values.
(Or wait 'til SQL server 2014)
/Hรฅkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 14, 2014 at 12:47 pm
Nice question, I had forgotten that sp_updatestats existed so I got it wrong. Maybe now I'll remember ๐
Tom
March 14, 2014 at 2:21 pm
nice explanation steve.
thanks.
March 16, 2014 at 2:12 am
sestell1 (3/14/2014)
OCTom (3/14/2014)
Koen Verbeeck (3/14/2014)
Richard Warr (3/14/2014)
Stewart "Arturius" Campbell (3/14/2014)
Interesting question, thanks Steve.Misread the question, thought it meant the highest level that a single command can be used...
ah well...
Same here :doze:
+1
Didn't get the intent of the question, so I choose database level.
Yup. Same here. :ermm:
Arrrgggh.... me too. :crazy:
I have to stop answering these first thing in the morning. :ermm:
- 1 :w00t:
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply