No announcements
Found 564409 threads
-
0 VotesLock Statistics
To re-enable statistics updates, remove the statistics with DROP STATISTICS and then run CREATE STATISTICS without the NORECOMPUTE ...Answered | 8 Replies | 1994 Views | Created by KG2014S - Monday, March 17, 2014 7:45 PM | Last reply by davidbaxterbrowne - Monday, March 17, 2014 10:31 PM
-
0 Votes
Update statistics
You can running UPDATE STATISTICS on Wed...Answered | 2 Replies | 2589 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
User defined statistics
Rahul, As u mentioned that table has only one row , so there will not any proformance gain on creating a statistics or indexes.Answered | 3 Replies | 4951 Views | Created by Rahul Sherawat - Tuesday, April 27, 2010 6:30 AM | Last reply by muralijv - Tuesday, April 27, 2010 2:35 PM -
0 Votes
Statistics 101 Questions
1.Statistics deal with column data "distribution" in tables.Answered | 1 Replies | 1620 Views | Created by edm2 - Tuesday, August 13, 2013 3:03 PM | Last reply by SimpleSQL - Tuesday, August 13, 2013 3:16 PM -
0 Votes
Auto Update Statistics
No, statistics are typically updated when SQL Server needs to run a query.Answered | 1 Replies | 2621 Views | Created by nadirsql - Tuesday, December 27, 2011 10:06 PM | Last reply by Erland Sommarskog - Tuesday, December 27, 2011 10:26 PM -
2 Votes
performance statistics
Select the contents of sys.dm_om_wait_stats into a table which beside the columns in the DMV also has a column that identifies the set.Answered | 11 Replies | 905 Views | Created by GKS001 - Thursday, February 18, 2016 9:26 PM | Last reply by Uwe Ricken - Monday, February 22, 2016 2:31 PM -
0 Votes
Question on sql statistics
When it uses that method, it basically assumes that the pages that are sampled will yield a representative distribution and cardinality of the column(s) for which the ...Answered | 9 Replies | 1873 Views | Created by Alok c Shahi - Saturday, March 1, 2014 4:55 PM | Last reply by Erland Sommarskog - Sunday, March 2, 2014 1:43 PM -
0 Votes
Indexes showing up as statistics??
only entries marked as statistics.Answered | 5 Replies | 948 Views | Created by John Couch - Wednesday, July 15, 2015 7:30 PM | Last reply by John Couch - Thursday, July 16, 2015 11:35 AM -
2 Votes
Why DTA suggests to create statistics?
In addition to the normal histogram and string statistics for the leftmost column, multi-column stats provide density information on the remaining ...Answered | 5 Replies | 3093 Views | Created by Tech_consultant - Friday, December 7, 2012 1:12 PM | Last reply by Dan Guzman - Saturday, December 8, 2012 9:53 PM -
1 Votes
Reg: Statistics in SQL Server...
These statistics are created on the key columns of the index.Answered | 2 Replies | 960 Views | Created by Venkata Vara - Tuesday, December 25, 2018 3:28 PM | Last reply by Emily Fei - Wednesday, December 26, 2018 3:25 AM -
0 Votes
is statistic are created auto matically.
Apparently on SQL Server 2008 (where I run the code below), it seems to be quite intelligent, and only auto-create the statistics when there are no suitable statistics already.Answered | 4 Replies | 1184 Views | Created by rajemessage - Friday, March 7, 2014 7:04 AM | Last reply by Gert-Jan Strik - Wednesday, March 12, 2014 11:09 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 | 5367 Views | Created by amendez - Tuesday, March 3, 2009 2:16 PM | Last reply by TiborK - Tuesday, March 3, 2009 8:38 PM -
0 Votes
Auto Create Statistics not working on server
But I can't find that any of them disables auto-creation of statistics.Answered | 9 Replies | 1533 Views | Created by DeeBeeGee - Monday, August 1, 2016 2:20 PM | Last reply by Erland Sommarskog - Wednesday, August 3, 2016 9:37 PM -
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 | 14910 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
Statistics information
No, the Statistics are not defined at the instance level and therefore you need to get to each database individually and then get the objects from that database.Answered | 2 Replies | 531 Views | Created by VijayKSQL - Thursday, October 19, 2017 9:20 PM | Last reply by Martin.Cairney - Friday, October 20, 2017 1:35 AM -
0 Votes
Schema Compare Incorrectly Scripting Statistics (column order discrepancy)
When I run a schema compare against databases PROD and DEV, it generates (among all the other scripts) a CREATE STATISTICS statement for PROD as ...Answered | 2 Replies | 4604 Views | Created by JacksonBlue - Tuesday, October 20, 2009 8:19 PM | Last reply by Jackson Blue - Saturday, October 24, 2009 12:59 PM -
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 | 1371 Views | Created by Rakesh Talla - Monday, April 22, 2013 8:25 AM | Last reply by Kalman Toth - Monday, April 22, 2013 12:47 PM -
0 Votes
Statistics and REBUILD indexes
For more information about SQL Server statistics, you can review the following links: SQL Server Statistics Questions We ...Answered | 8 Replies | 1376 Views | Created by subu999 - Tuesday, August 26, 2014 2:06 PM | Last reply by Lydia Zhang - Wednesday, August 27, 2014 6:54 AM -
2 Votes
Update Statistics
Statistics should be updated periodically, but not before each run.Answered | 11 Replies | 5191 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 | 4628 Views | Created by James12314909 - Wednesday, November 14, 2012 5:49 PM | Last reply by James12314909 - Monday, November 19, 2012 2:40 PM
No announcements
