Forum Replies Created

Viewing 15 posts - 23,176 through 23,190 (of 49,552 total)

  • RE: Statistics debate

    Just bear in mind that rebuild only update's the statistics of the index that was rebuilt. It won't update the column statistics. So you may need to update those manually....

    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

    September 29, 2011 at 11:20 am

    #1388532

  • RE: Lock acquired/released infinite loop

    waxingsatirical (9/29/2011)

    Hi Guys,

    There is a particular statement in one of my stored procedures that is causing me a headache. As far as I can see it's a very straight forward...

    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

    September 29, 2011 at 10:24 am

    #1388494

  • RE: Are the posted questions getting worse?

    Chad Crawford (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    It is...

    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

    September 29, 2011 at 10:15 am

    #1388490

  • RE: option of pinning the tables in memory

    No, it does not.

    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

    September 29, 2011 at 9:25 am

    #1388453

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    Woohoo

    Now, when is your...

    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

    September 29, 2011 at 8:50 am

    #1388424

  • RE: Are the posted questions getting worse?

    Chapter 1 of the book is now available for free on Simple-Talk

    http://www.simple-talk.com/sql/performance/a-performance-troubleshooting-methodology-for-sql-server/

    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

    September 29, 2011 at 8:28 am

    #1388400

  • RE: If table is Clustered on RID, will index1 = [col2,col3] work the same as index2 = [col2,col3,RID]

    Do you have any queries that need RID in the index definition? Do you have any queries that filter on both, join on both, aggregate on both? If not, remove...

    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

    September 29, 2011 at 8:21 am

    #1388393

  • RE: Are the posted questions getting worse?

    WayneS (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    Hmm. Looking at 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

    September 29, 2011 at 7:18 am

    #1388353

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/29/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    Well done Gail....

    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

    September 29, 2011 at 5:21 am

    #1388285

  • RE: Urgent Help!!! on Function

    What's wrong with it (other than slow, which it is because it's a function)?

    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

    September 29, 2011 at 5:20 am

    #1388284

  • RE: Sql server doesnt release memory.

    No, SQL doesn't release memory. That's how it's designed (and it's documented that way)

    You need to tell SQL how much memory on the server it is allowed to have (max...

    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

    September 29, 2011 at 5:19 am

    #1388283

  • RE: If table is Clustered on RID, will index1 = [col2,col3] work the same as index2 = [col2,col3,RID]

    MadTester (9/29/2011)

    great, then I can log a defect against all those indexes which explicitly include a clustered column as part of the non clustered index.

    No!!!

    Don't depend on SQL's behaviour. If...

    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

    September 29, 2011 at 5:13 am

    #1388278

  • RE: If table is Clustered on RID, will index1 = [col2,col3] work the same as index2 = [col2,col3,RID]

    MadTester (9/29/2011)

    My guess is yes, and the RID column adds size to index2 since I guess it is stored twice, once as an explicit column, and once as part of...

    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

    September 29, 2011 at 5:11 am

    #1388277

  • RE: Are the posted questions getting worse?

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    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

    September 29, 2011 at 3:50 am

    #1388253

  • RE: ROW_NUMBER() OVER (PARTITION BY *** ORDER BY ***) excluding NULL values

    Did you try Howard's suggestion?

    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

    September 29, 2011 at 3:25 am

    #1388244

Viewing 15 posts - 23,176 through 23,190 (of 49,552 total)