Forum Replies Created

Viewing 15 posts - 35,896 through 35,910 (of 49,552 total)

  • RE: Introduction to Indexes: Part 2 – The clustered index

    John Colby (11/12/2009)

    I had been (up until reading this article) creating a clustered index that was also a cover index, i.e. the index had every single field.

    The clustered index...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 7:30 am

    #1078337

  • RE: directory lookup for the file failed with the operating system error 2

    Please post the code used to create the DB and the exact error message that you get.

    Either write the create DB statement yourself or use the 'script' button on the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 5:29 am

    #1078270

  • RE: Performance issue due to update statistics

    Bhaskar Basak (11/12/2009)

    thanks a lot for the info.

    The table has almost 10 mn records and for today only 100K has added so as per the default threshhold the behaviour...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 5:24 am

    #1078268

  • RE: Introduction to Indexes: Part 2 – The clustered index

    INNOCENT GUMBO (11/12/2009)

    I am not quite sure about many Clustered Indexes here. Since the concept tells us that they are part of the table and determine the Ordering of data,then...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 3:32 am

    #1078232

  • RE: Performance issue due to update statistics

    Expected behaviour. Stats are only updated after a certain threshold of rows change. On larger tables that's 20%. If you find that you need to manually update stats then either...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 3:32 am

    #1078231

  • RE: Dimensions disappear from the dataset when add a new parameter to the SSRS report

    Sy-1148362 (11/12/2009)

    SSC is an ocean and people may or may not look at my issue.

    Yes, that's true, however forum etiquette (here and virtually everywhere else) is to pick the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 3:25 am

    #1078229

  • RE: Dimensions disappear from the dataset when add a new parameter to the SSRS report

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic817651-150-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:50 am

    #1078215

  • RE: Page Reads/sec is a very high number

    From books online:

    cntr_value

    Current value of the counter.

    Note:

    For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:41 am

    #1078213

  • RE: Why would an identity clustered index get fragmented?

    Are you shrinking the DB? Maintenance plan or auto_shrink? That'll fragment anything.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:33 am

    #1078210

  • RE: Covering Index Question

    The index that you have there is completely useless for seeks. The leading column is not used in the where clause at all. That query will execute with an index...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:33 am

    #1078209

  • RE: Restore DB with Norecovery

    tsd_suresh (11/12/2009)

    I am trying to restore DB with no recovery model for Log shipping. while i try to restore from backup with No recovery model . ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:32 am

    #1078208

  • RE: Introduction to Indexes: Part 2 – The clustered index

    TheSQLGuru (11/11/2009)

    You made a very important piece of information public there: GL transactions. In my experience with financial data GL rows are almost never updated/deleted. That means...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:24 am

    #1078206

  • RE: What are the Potential Dangers of Too Many Statistics?

    GDI Lord (11/12/2009)

    GilaMonster (11/10/2009)

    DTA often suggests multi-column statistics, which Auto_Create will never create.

    Why?

    Why does DTA recommend them or why does auto_create never create them?

    For the first, I don't know. Personally...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:14 am

    #1078204

  • RE: Introduction to Indexes: Part 2 – The clustered index

    hlam-1032421 (11/11/2009)

    With comments like this I run for the exit:

    … good clustering. One school says to put the clustered index on the column or set of columns that would be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 12, 2009 at 2:12 am

    #1078203

  • RE: Trouble with Distinct in SQL2000

    blambu56 (11/11/2009)

    I want to make it a concatenated PK with ClientNumber and ClientAcctNumber for the TMP9999 table. That would be the only guaranteed unique data in this file.

    But the combination...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 11, 2009 at 12:37 pm

    #1077993

Viewing 15 posts - 35,896 through 35,910 (of 49,552 total)