Forum Replies Created

Viewing 15 posts - 38,551 through 38,565 (of 49,552 total)

  • RE: Index question for the guru's out there...

    Personally, if it were me, I'd create indexes to support the two or three most run queries, and then later re-evaluate to see if more were needed.

    My standard technique:

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    June 9, 2009 at 11:08 am

    #1006901

  • RE: Forums on your Resume/CV

    jcrawf02 (6/9/2009)

    GilaMonster (6/9/2009)

    Chances are here that I wouldn't find anything.

    And yet you'd find you. Maybe you should reconsider that?

    Last interview I did was just over a year ago. Don't...

    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

    June 9, 2009 at 10:35 am

    #1006858

  • RE: Need Help with TRIM

    Drop the angle brackets. I meant replace <Format code> with the format code. Angle brackets designates a placeholder. something to be replaced with an actual value.

    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

    June 9, 2009 at 10:33 am

    #1006856

  • RE: Late Subscription Notifications..?

    I'm getting them anything from 1 hour to 2 days late. Got a notification this morning for a post made on Sunday.

    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

    June 9, 2009 at 9:51 am

    #1006822

  • RE: Fixing Fragmentation After Shrinking

    Steve Jones - Editor (6/9/2009)

    Actually I would think that you would want to rebuild indexes after physical fragmentation as well. I don't have a ref, but anytime you move physically...

    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

    June 9, 2009 at 9:46 am

    #1006812

  • RE: Fixing Fragmentation After Shrinking

    GSquared (6/9/2009)

    Besides, it's necessary, since the indexes point to actual disk locations, and having them point to incorrect sectors isn't a good thing.

    ?????

    As far as I'm aware, nothing within a...

    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

    June 9, 2009 at 9:40 am

    #1006808

  • RE: Support Your Local SQL Server User’s Group

    Just one additional point. Not all SQL usergroups are PASS chapters (mine isn't yet). So if there isn't a PASS chapter in the area, ask around and see if there's...

    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

    June 9, 2009 at 9:36 am

    #1006800

  • RE: Fixing Fragmentation After Shrinking

    fbonneville (6/9/2009)

    But if you rebuild your indexes after shrinking the data files, won't this force the data files to grow again during the rebuild essentially negating all of your work?

    It...

    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

    June 9, 2009 at 9:33 am

    #1006791

  • RE: Fixing Fragmentation After Shrinking

    GSquared (6/9/2009)

    Indexes need to be rebuilt after physical defragmentation, per Microsoft.

    Ref please?

    I can't see why. Index fragmentation is about the order of pages in the data file, shouldn't be affected...

    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

    June 9, 2009 at 9:30 am

    #1006788

  • RE: sp execution plans

    dallas13 (6/9/2009)

    Now if i try the same thing with select statement and supply 100 different parameters then wht will be the result?

    sql will create 100 different...

    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

    June 9, 2009 at 9:18 am

    #1006777

  • RE: Fixing Fragmentation After Shrinking

    No, no and no.

    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

    June 9, 2009 at 9:17 am

    #1006776

  • RE: O(n) , O(n log n), O(n^2)

    Tom Brown (6/9/2009)

    I may be totally wrong or this could be too simplistic, but thats what I understood from the Wiki article and various other researching.

    That's pretty much...

    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

    June 9, 2009 at 7:27 am

    #1006673

  • RE: query with joins and functions , how to optimize , it is taking 58 min.. to retrive the 998 records . query with joins ,functions

    Please post the query, table definitions, index definitions, function definitions and the execution plan (saved as a .sqlplan file, zipped and attached)

    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

    June 9, 2009 at 5:28 am

    #1006589

  • RE: How to Backup and Restore a sql server2005 database

    Look up BACKUP DATABASE and RESTORE DATABASE in Books Online (the SQL help file). There's a good amount of info there.

    Backups are online operations, nothing to worry about 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

    June 9, 2009 at 5:27 am

    #1006588

  • RE: Converting a date within the WHERE or JOIN areas

    There is. Calculated persisted columns can be indexed. Full details in Books Online.

    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

    June 9, 2009 at 5:14 am

    #1006578

Viewing 15 posts - 38,551 through 38,565 (of 49,552 total)