No announcements
Found 668784 threads
-
0 VotesUpdate Statistics
You have had to do 2,000,000 modifications for the column(s) in order for sp_updatestats to update the statistics.Answered | 9 Replies | 2185 Views | Created by VijayKSQL - Thursday, September 5, 2013 5:36 AM | Last reply by TiborK - Thursday, September 5, 2013 11:08 AM
-
0 Votes
Update statistics
It is recommended to stop Auto update statistics and run the update statistics weekely once during half peak hours.Answered | 4 Replies | 1474 Views | Created by Rakesh Talla - Monday, April 22, 2013 8:25 AM | Last reply by Kalman Toth - Monday, April 22, 2013 12:47 PM -
2 Votes
Update 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 -
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 -
0 Votes
Update statistics
I wrote a custom script to update statistics more intelligently.Answered | 4 Replies | 1675 Views | Created by venkat83 - Monday, August 25, 2014 4:01 PM | Last reply by Satish Kartan, MCITP - Monday, August 25, 2014 5:01 PM -
3 Votes
Update Statistics
Hi, If statistics are not updated, Will it wont fetch the datas?Answered | 9 Replies | 6014 Views | Created by Ranjith12 - Wednesday, February 9, 2011 1:49 PM | Last reply by SQLMojoe - Sunday, February 13, 2011 6:22 PM -
0 Votes
Update statistics
You can running UPDATE STATISTICS on Wed...Answered | 2 Replies | 2689 Views | Created by Surya.chamala - Saturday, September 14, 2013 7:24 PM | Last reply by Uri Dimant - Monday, September 16, 2013 5:23 AM -
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 -
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
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 -
1 Votes
Rebuild indexes and Update Statistics?
To obtain statistics on partitioned indexes by scanning all the rows in the table, use CREATE STATISTICS or UPDATE STATISTICS with the FULLSCAN clause.Answered | 6 Replies | 15046 Views | Created by NguyenBL - Monday, April 23, 2012 9:07 PM | Last reply by mi-usuario - Friday, September 7, 2018 3:07 PM -
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 -
0 Votes
ALTER INDEX / UPDATE STATISTICS
Ok, so I'm just goin to do the ALTER INDEX and omit UPDATE STATISTICS statement because the alter does update the statistics.Answered | 9 Replies | 5463 Views | Created by amendez - Tuesday, March 3, 2009 2:16 PM | Last reply by TiborK - Tuesday, March 3, 2009 8:38 PM -
5 Votes
updating statistics on big tables
article, UPDATE STATISTICS can use tempdb to sort the sample of rows for building statistics.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
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
Create Statistics and Update Statistics command--Access Path
When statistics are created and updated, the optimizer must choose an access path to gather the statistics.Answered | 1 Replies | 1108 Views | Created by LearnerSql - Thursday, June 26, 2014 11:46 PM | Last reply by RAJU RG - Friday, June 27, 2014 2:29 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 -
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 -
4 Votes
Frequency of Updating Statistics
Please read the below ...Answered | 7 Replies | 5421 Views | Created by Reddy Balaji C - Monday, August 13, 2012 2:17 AM | Last reply by SQLZealots - Tuesday, August 14, 2012 10:28 AM -
0 Votes
Auto Update Statistics
No, statistics are typically updated when SQL Server needs to run a query.Answered | 1 Replies | 2707 Views | Created by nadirsql - Tuesday, December 27, 2011 10:06 PM | Last reply by Erland Sommarskog - Tuesday, December 27, 2011 10:26 PM - Items 1 to 20 of 668784 Next ›
No announcements
