No announcements
Found 889341 threads
-
2 VotesUpdate 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 | 2093 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
-
1 Votes
Statistics Update Block
So you mean select query was blocked by update stats right ?Answered | 6 Replies | 1429 Views | Created by Priya Bange - Monday, September 25, 2017 2:12 PM | Last reply by Erland Sommarskog - Monday, September 25, 2017 10:12 PM -
1 Votes
Update Statistics with Fullscan, does it cause blocking?
It showed user queries being blocked by the update statistics SPID.Answered | 7 Replies | 25831 Views | Created by Casey Smith - Friday, January 29, 2010 11:07 PM | Last reply by Dan Guzman - Monday, December 18, 2017 12:39 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 | 1368 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 only help the optimizer to determine the best query plan.Answered | 11 Replies | 5188 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
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 | 2075 Views | Created by VijayKSQL - Thursday, September 5, 2013 5:36 AM | Last reply by TiborK - Thursday, September 5, 2013 11:08 AM -
3 Votes
Update Statistics
Hi, If statistics are not updated, Will it wont fetch the datas?Answered | 9 Replies | 5908 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 | 2585 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
Auto Update Statistics not updating the stats
Since there is only one way to execute to the query , optimizer thinks the statistics does not really help, so, does not bother to update them.Answered | 8 Replies | 3443 Views | Created by Stan210 - Thursday, January 15, 2015 12:30 AM | Last reply by Stan210 - Tuesday, January 20, 2015 4:21 AM -
0 Votes
Degraded query performance after UPDATE STATISTICS WITH FULLSCAN
Are the same indexes used before and after the update statistics?Answered | 4 Replies | 6792 Views | Created by jmaikido - Saturday, August 31, 2013 5:35 AM | Last reply by wBob - Sunday, September 1, 2013 5:41 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 | 6851 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
Update Statistics
http://www.benjaminnevarez.com/2010/07/rebuilding-indexes-vs-updating-statistics/Answered | 5 Replies | 796 Views | Created by adilrehman - Friday, July 20, 2018 5:02 AM | Last reply by Shanky_621 - Friday, July 20, 2018 7:39 AM -
1 Votes
Rebuild indexes and Update Statistics?
Instead, the query optimizer uses the default sampling algorithm to generate these statistics.Answered | 6 Replies | 14907 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
No, statistics are typically updated when SQL Server needs to run a query.Answered | 1 Replies | 2617 Views | Created by nadirsql - Tuesday, December 27, 2011 10:06 PM | Last reply by Erland Sommarskog - Tuesday, December 27, 2011 10:26 PM -
6 Votes
use of update statistics?
Hi g2sk1986, As i know Whenever we write any query ,the query optimizer will prepare a execution plan and work according to that execution plan ...Answered | 4 Replies | 4199 Views | Created by SaiKumar G - Thursday, June 21, 2012 3:45 PM | Last reply by SQLBAG - Saturday, June 23, 2012 9:28 AM -
0 Votes
Auto Update statistics
Hi, How often auto update statistics run when it is on?Answered | 2 Replies | 1356 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
Which locks are acquired by Update Statistics
You don't want the table definition to change while the query is running.Answered | 3 Replies | 1931 Views | Created by ggolub - Friday, October 24, 2014 12:09 AM | Last reply by Erland Sommarskog - Friday, October 24, 2014 7:06 AM -
1 Votes
update statistics takes too long
UPDATE STATISTICS doesn't causing blocking so it's OK to run as long as it's not causing IO bottleneck to your production workload.Answered | 10 Replies | 14122 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
Update statistics for File Table
Hi krishh.kk, Correct me if I’m wrong, it seems like blocking to me.Answered | 2 Replies | 924 Views | Created by krishh.kk - Tuesday, July 19, 2016 2:09 PM | Last reply by Lin Leng - Saturday, July 30, 2016 3:15 AM -
0 Votes
DMV query to update statistics (not indices) from VLDB
Hi HSever, "but I would like to get a rowmodificationCounter (or any other statistics trigger) the same I can find for indices...Answered | 3 Replies | 1047 Views | Created by HSever - Monday, July 29, 2019 5:51 PM | Last reply by HSever - Tuesday, July 30, 2019 1:14 PM - Items 1 to 20 of 889341 Next ›
No announcements
