No announcements
Found 564411 threads
-
2 VotesUpdate Statistics
Statistics should be updated periodically, but not before each run.Answered | 11 Replies | 5298 Views | Created by psingla - Wednesday, April 27, 2011 9:51 AM | Last reply by Eric Isaacs - Wednesday, April 27, 2011 10:45 PM
-
4 Votes
Update statistics on ifts_compFragment_#####
I figured out I could create statistics doing the following: create statistics DB_FTC_1349579846_395574 on [DB].Answered | 9 Replies | 4728 Views | Created by James12314909 - Wednesday, November 14, 2012 5:49 PM | Last reply by James12314909 - Monday, November 19, 2012 2:40 PM -
0 Votes
Update Statistics
http://www.benjaminnevarez.com/2010/07/rebuilding-indexes-vs-updating-statistics/Answered | 5 Replies | 901 Views | Created by adilrehman - Friday, July 20, 2018 5:02 AM | Last reply by Shanky_621 - Friday, July 20, 2018 7:39 AM -
5 Votes
updating statistics on big tables
Or at the least use filtered statistics (but it depends on access pattern).Answered | 7 Replies | 6994 Views | Created by Samantha v - Friday, April 15, 2016 6:39 AM | Last reply by Andrea Caldarone - Tuesday, April 19, 2016 9:11 AM -
0 Votes
SQL 2008: Auto generated statistics/indexes _WA_Sys_
The statistics _WA_Sys_00000003_7D78A4E7 above is related to the single-column statistics on a table.Answered | 3 Replies | 13851 Views | Created by techresearch7777777 - Friday, August 5, 2011 7:52 PM | Last reply by Stephanie Lv - Tuesday, August 9, 2011 8:54 AM -
0 Votes
Auto Update Statistics not updating the stats
Hi Stan By any chance do u have "auto update statistics asynchronous " enable ?Answered | 8 Replies | 3552 Views | Created by Stan210 - Thursday, January 15, 2015 12:30 AM | Last reply by Stan210 - Tuesday, January 20, 2015 4:21 AM -
1 Votes
How does the query optimizer gets the statistics information
Each set of statistics is stored as a table-level object that tracks the distribution of values across the first column in any given set.Answered | 15 Replies | 1327 Views | Created by juniorkiran - Saturday, August 11, 2018 12:19 PM | Last reply by TiborK - Monday, August 13, 2018 2:14 PM -
0 Votes
Rebuild Indexing and Update Statistics
currently i am doing first rebuild indexing than update statistics.Answered | 11 Replies | 13035 Views | Created by Agha Ali - Tuesday, May 11, 2010 12:55 PM | Last reply by limssd - Wednesday, February 8, 2017 3:22 AM -
1 Votes
update statistics takes too long
As Josh says, you will be left without unupdated statistics.Answered | 10 Replies | 14382 Views | Created by bestrongself - Wednesday, January 1, 2014 1:06 AM | Last reply by Erland Sommarskog - Wednesday, January 1, 2014 10:27 PM -
0 Votes
Counters and Statistics
Thanks Joe Bill Thurston said: Can you recommend good web statistics code (with counter) to add to my site?Answered | 2 Replies | 3941 Views | Created by Bill Thurston - Friday, April 25, 2008 5:18 PM | Last reply by Bill Thurston - Friday, April 25, 2008 5:52 PM -
0 Votes
Warning of No statistics on a column
Or do you mean that you see plans saved in Query Store with this warning after you ran UPDATE STATISTICS?Answered | 20 Replies | 2183 Views | Created by Curendra - Tuesday, October 22, 2019 9:33 AM | Last reply by Curendra - Friday, October 25, 2019 4:03 AM -
0 Votes
Statistics, strategy
1 month does not make them "bad" statistics.Answered | 5 Replies | 661 Views | Created by Enric Vives - Friday, July 8, 2016 11:46 AM | Last reply by Enric Vives - Friday, July 8, 2016 12:37 PM -
0 Votes
Statistical Calculations
Actually Chart provides you with a number of statistical formulas.Answered | 1 Replies | 5260 Views | Created by EJLindsay - Monday, January 12, 2009 7:49 PM | Last reply by Victor Arakcheev - MSFT - Tuesday, January 13, 2009 6:43 PM -
2 Votes
Update Statistics blocks update queries?
So, you wouldn't be able to change a table's definition whilst UPDATE STATISTICS is running, for example.Answered | 2 Replies | 2177 Views | Created by Kalyan Chakravarthi (MCP) - Monday, August 19, 2013 12:57 PM | Last reply by Andrew Bainbridge - Monday, August 19, 2013 1:17 PM -
0 Votes
udpate statistics resample
Hi, The statistics in SQL Server is stored in statblob, a LOB column.Answered | 3 Replies | 2808 Views | Created by Daniel, Wu - Tuesday, November 22, 2011 10:25 AM | Last reply by Sankar Reddy - Tuesday, November 22, 2011 11:51 PM -
1 Votes
Index and Statistics
However, the index statistics will become stale if indexed data changes and stats aren't updated or the index rebuilt.Answered | 8 Replies | 3591 Views | Created by nadirsql - Tuesday, June 14, 2011 3:33 PM | Last reply by Dan Guzman - Wednesday, June 15, 2011 3:38 AM -
0 Votes
Update statistics
Varun, You can also use Ola hallengren index solution.Answered | 4 Replies | 1200 Views | Created by Raje14 - Thursday, September 10, 2015 6:52 AM | Last reply by Shanky_621 - Thursday, September 10, 2015 8:38 AM -
0 Votes
Cancel update statistics
I guess the statistics are OK because it will not simply erase all the statistics at once and start rebuilding them from scratch but does updates one by one.Answered | 1 Replies | 9370 Views | Created by CarlosDeAbreu2009 - Thursday, March 18, 2010 6:13 PM | Last reply by Ranjith Kumar S - Thursday, March 18, 2010 7:00 PM -
0 Votes
Auto Update statistics
Hi, How often auto update statistics run when it is on?Answered | 2 Replies | 1447 Views | Created by Surya.chamala - Thursday, February 20, 2014 9:00 PM | Last reply by Shanky_621 - Thursday, February 20, 2014 9:49 PM -
0 Votes
Update statistics
HI, How long the update statistics job used to run on the largest database(of size 1 TB)?Answered | 1 Replies | 1847 Views | Created by Surya.chamala - Saturday, September 14, 2013 7:18 PM | Last reply by Shanky_621 - Sunday, September 15, 2013 4:44 AM
No announcements
