Post reply

Missing Column Statistics in tempdb

  • December 18, 2012 at 4:59 am

    #286348

    I have a server which is not running optimally and I checked the default trace. I have around 600 entries in the default trace which are all Missing Column Statistics and the database is tempdb.

    is_auto_create_stats_on and is_auto_update_stats_on are both 1 for tempdb.

    Why do I have the warning and how do I fix it?

    Thanks

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • May 13, 2015 at 2:43 pm

    #1797688

    I'm seeing the same thing but I have over 34,000 of these messages for tempdb.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • May 13, 2015 at 10:14 pm

    #1797745

    Have you checked the data types? Some datatypes can't have statistics...

    From BOL:

    column [ ,…n]

    Specifies the key column or list of key columns to create the statistics on. You can specify any column that can be specified as an index key column with the following exceptions:

    Xml , full-text, and FILESTREAM columns cannot be specified.

    Computed columns can be specified only if the ARITHABORT and QUOTED_IDENTIFIER database settings are ON.

    CLR user-defined type columns can be specified if the type supports binary ordering. Computed columns defined as method invocations of a user-defined type column can be specified if the methods are marked deterministic.

    ... and I wanted to add - SQL Server still gives you a warning.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply