No announcements
Found 4086264 threads
-
0 VotesWarning of No statistics on a column
For a query execution plan is showing warning of no statistics on a column but the statistics for that column ...Answered | 20 Replies | 1472 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 on a Column question
I am working on an app that needs to run statistics on data. A lot of data. The data lives in one table, but each calculation may require one ...Answered | 1 Replies | 7164 Views | Created by BryanCC - Thursday, September 22, 2011 9:22 PM | Last reply by BryanCC - Thursday, September 22, 2011 10:54 PM -
2 Votes
How to add statistics to a column
My client has a big hairy query that is performing really poorly. When I look at the query plan it shows a warning on a table scan node that says ...Answered | 9 Replies | 1082 Views | Created by TheBrenda - Wednesday, October 25, 2017 9:14 PM | Last reply by Will_Kong - Tuesday, October 31, 2017 10:20 AM -
0 Votes
SQL04151 Warning on UPDATE STATISTICS on temporary table
I have reported this as a bug on Connect. Feedback ID:Answered | 4 Replies | 8408 Views | Created by noonie - Tuesday, June 1, 2010 7:03 AM | Last reply by Figo Fei - Friday, June 4, 2010 6:41 AM -
1 Votes
Multiple statistics on the same column
query, with 4 statistics on the same column and only in the situation when the first statistic (S_value_01) whas the statistic that was up to date (row_mods = 0, last ...Answered | 6 Replies | 2075 Views | Created by Dmitry Otblesk - Friday, October 4, 2013 3:02 AM | Last reply by Dmitry Otblesk - Monday, October 7, 2013 3:53 PM -
0 Votes
Column Statistics
the query execeution plan i get the following warning on the clustered index seek. Columns with no Statistics: Col3,Col2. How can i ...Answered | 10 Replies | 15556 Views | Created by SQLUser1979 - Thursday, March 4, 2010 3:26 PM | Last reply by SQLUser1979 - Thursday, March 4, 2010 5:21 PM -
0 Votes
index and column statistics
the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows. sp_updatestats can trigger a recompile ...Answered | 6 Replies | 5656 Views | Created by Ryan_XH - Friday, June 3, 2011 6:55 PM | Last reply by Arbi Baghdanian - Friday, June 3, 2011 7:40 PM -
0 Votes
Missing Column Statistics
I think that AUTO CREATE STATISTICS cannot create statistics on more then one column and maybe is this reason why you see a lot of ...Answered | 5 Replies | 8248 Views | Created by Ryan_XH - Friday, June 3, 2011 3:40 PM | Last reply by JRStern - Saturday, June 4, 2011 5:32 PM -
0 Votes
Repeated warning - Columns with no statistics - Win2K12 SQL R2
execute. On running execution plans observed that some warnings are seen on columns which are primary keys. Columns with no statistics ...Answered | 6 Replies | 1800 Views | Created by shwetank07091988 - Wednesday, November 18, 2015 12:53 PM | Last reply by Tom Phillips - Thursday, November 19, 2015 1:43 PM -
0 Votes
Manual column usage statistics
was used 105 times, etc. is there a tool to get this kind of statistics? BTW: I tried it with DTA but I got no ...Answered | 1 Replies | 4673 Views | Created by fari_the_user - Monday, May 25, 2009 2:06 PM | Last reply by silna - Monday, May 25, 2009 2:25 PM -
0 Votes
Custom Statistics Show No Details
I made a custom statistics object for a partitioned table. There's no information available in the details pane of the Statistic. Then I ran the ...Answered | 5 Replies | 6126 Views | Created by Abercrombie07 - Wednesday, January 12, 2011 8:56 PM | Last reply by AkimZ - Friday, January 14, 2011 5:43 PM -
0 Votes
set statistics on a table
You can deceive the optimizer by using ROWCOUNT and PAGECOUNT options of UPDATE STATISTICS.I don't this its documented in MSDN(not sure).I rememebr reading this in a SQL Server ...Answered | 1 Replies | 2325 Views | Created by Daniel, Wu - Friday, November 4, 2011 12:45 AM | Last reply by Zainu - Friday, November 4, 2011 6:31 AM -
0 Votes
Incorrect Statistics Column Order on a Composite Clustered PK
Hello All, I've encountered a bit of strange behavior with statistics in a database I am working on. Basically I have ...Answered | 6 Replies | 3405 Views | Created by Aleksandr Krymskiy - Tuesday, August 28, 2012 2:58 PM | Last reply by Samuel ua - Wednesday, February 11, 2015 1:05 PM -
2 Votes
Unit of time-statistics in "client statistics"
statistics are useful in determining how much time the network and client components contribute to the total response time of a query. Management Studio supports collecting ...Answered | 2 Replies | 20374 Views | Created by Nikolaj Berg Amondsen - Tuesday, August 1, 2006 11:32 AM | Last reply by RobNicholson, MCSM - Friday, March 2, 2012 12:52 AM -
0 Votes
Automation of statistics generations
You can create a stored procedure to update statistics on either all tables or just specific columns. See Example H inAnswered | 3 Replies | 733 Views | Created by bozza - Thursday, July 21, 2016 4:15 AM | Last reply by Sonya Marshall - Wednesday, August 17, 2016 9:21 PM -
0 Votes
Question on sql statistics
pages that are sampled will yield a representative distribution and cardinality of the column(s) for which the statistics are ...Answered | 9 Replies | 1677 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
Getting total no. of records based on a column?
from "Read" column, will the value returned be string, bool or int? "Read" SqlDbType is bit. Result will be a single value ...Answered | 4 Replies | 2 Views | Created by Anonymous - Friday, February 10, 2012 6:17 AM | Last reply by Anonymous - Saturday, February 11, 2012 8:57 PM -
6 Votes
use of update statistics?
http://msdn.microsoft.com/en-us/library/ms187348.aspx Technical explanation of Statistics:Answered | 4 Replies | 3993 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
Statistics
have very specific requirements. In most cases statistics that is based on a sample is good enough (it might be a case if you have an extremely unbalanced data ...Answered | 3 Replies | 1029 Views | Created by bills1988 - Saturday, December 12, 2015 9:22 AM | Last reply by Uri Dimant - Tuesday, December 15, 2015 6:53 AM -
4 Votes
Frequency of Updating Statistics
unfortunately the only way to find out your statistics are outdated is when it is to late. I think it's good practice to include sp_updatestats command in code on a DB when ...Answered | 7 Replies | 5089 Views | Created by Reddy Balaji C - Monday, August 13, 2012 2:17 AM | Last reply by SQLZealots - Tuesday, August 14, 2012 10:28 AM - Items 1 to 20 of 4086264 Next ›
No announcements
