UPDATE STATISTICS undocumented options

Tips Tricks and Advice from the SQL Server Query Optimization Team | storage bench

Fri, 19 Jun 2009 11:03:26 GMT

PingBack from http://thestoragebench.info/story.php?id=9514

Tips Tricks and Advice from the SQL Server Query Optimization Team | debt settlement program

Mon, 15 Jun 2009 20:02:22 GMT

PingBack from http://edebtsettlementprogram.info/story.php?id=24748

Tips Tricks and Advice from the SQL Server Query Optimization Team | Quick Diets

Tips Tricks and Advice from the SQL Server Query Optimization Team | Quick Diets — Wed, 10 Jun 2009 06:13:19 GMT

PingBack from http://quickdietsite.info/story.php?id=4048

Online Indexing operations enhancement in SQL Server 2005

SQL Server tools — Sat, 17 Mar 2007 21:35:18 GMT

In SQL Server designing efficient indexes is paramount to achieving good database and application performance.

How to create fake statistics for testing query plans

SQL Server Storage Engine — Tue, 13 Mar 2007 04:49:53 GMT

This is very cool - an undocumented option to UPDATE STATISTICS that allows you to fool the server into

update statistics undocumented

roy ashbrook — Fri, 09 Mar 2007 16:59:04 GMT

these are undocumented for a reason as they will affect performance and you will break your sql production

dosql :: Used update statistics on DEV env to get the PRD execution plan

dosql :: Used update statistics on DEV env to get the PRD execution plan — Fri, 01 Dec 2006 00:45:15 GMT

PingBack from http://www.dosql.com/blog/?p=87

re: UPDATE STATISTICS undocumented options

QueryOptTeam — Mon, 31 Jul 2006 21:02:10 GMT

Unfortunately, at the moment there is no way to change the statistics for internal hidden tables like those used for Full Text Search. This is a limitation we should definitely attempt to remove in some future release.

Thanks you for the great feedback!
Stefano

re: UPDATE STATISTICS undocumented options

Michael Zilberstein — Mon, 31 Jul 2006 04:24:36 GMT

Thank you for this post! It came exectly at time, while I was breaking my head trying to simulate behavior of a table with 70 Gb of data without actually loading it.
My question is - is there any way to fool Full-Text index? When I created Full-Text index on my table and executed query with CONTAINS(...), the "Estimated Row Count" in the execution plan was again 1 instead of 3M estimated row count in the query without CONTAINS(...).

re: UPDATE STATISTICS undocumented options

Wesley Backelant — Wed, 26 Jul 2006 09:29:45 GMT

Thanks for the extra explanation.

I do understand that nothing can compete with realistic data. But I'd rather see people try some first optimizations with artificial statistics than not optimizing at all because they have no time to generate test data, especially since I'm typically the one who has to solve it once it goes to production :-)

I still love the black art of query tuning though ;-)

Wesley