|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
bug: "autostat" of an index reported by SQL Server Management Studio for 2005Do not know if any one has complained this to Microsoft.
SQL server management studio does not seem to display the "autostat" of an index correctly. The value in SQL server management studio is always the reverse of the value from "sp_autostats". to reproduce, high light a table in object explorer -> right click to select Modify -> click "manage indexes and keys" -> select the index , the value of "Re-compute Statistics" is always the reverse of the value of the corresponding index from "sp_autostats". Thanks. Kong (lik***@email.com) writes:
> Do not know if any one has complained this to Microsoft. Actually, I can't recall having seen this particular issue reported.> > SQL server management studio does not seem to display the "autostat" of > an index correctly. The value in SQL server management studio is > always the reverse of the value from "sp_autostats". > > to reproduce, high light a table in object explorer -> right click to > select Modify -> click "manage indexes and keys" -> select the index , > the value of "Re-compute Statistics" is always the reverse of the value > of the corresponding index from "sp_autostats". When playing around, it appears that someone has gotten confused over the DLL, where the option is STATISTICS_NORECOMPUTE=ON/OFF. If you believe what the dialog says, and change No to Yes, you will alter the setting. The place to report bugs like this is http://lab.msdn.microsoft.com/ProductFeedback/, and I encourage you to go there. By the way, if you right-click the index, select Properties, and go to the Options page, you will see that on this screen they have it right. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  
Other interesting topics
SSMS 2005 Default DB in Solution Explorer when creating new query
Enterprise Mgr - alter table fails New Query with Current Connection SQL Server Management Studio error on connection SQL 2005 Target Server Connection vs. Local Server Connection SQL Enterprise Manager SQL Management Studio 2005 Upgrading Database Diagrams to 2005 SS05 Profiler questions Auto-refresh the output of the 'Open Table" action |
|||||||||||||||||||||||
