Forum Replies Created

Viewing 15 posts - 22,756 through 22,770 (of 49,552 total)

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    And maybe this: http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    October 24, 2011 at 8:27 am

    #1398704

  • RE: performance of the query and index

    http://sqlskills.com/BLOGS/PAUL/post/Do-yourself-a-favor-Trust-No-One.aspx

    Also note that's an incredibly old article that you referenced.

    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

    October 24, 2011 at 7:04 am

    #1398652

  • RE: Searching smallest unused number

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    October 24, 2011 at 5:37 am

    #1398619

  • RE: Are the posted questions getting worse?

    I prefer picking a sentence from towards the end of the article, it eliminates those posting just an extract of the article. Doing that, this one turned up:

    http://toostep.com/insight/daily-dba-morning-check-list

    Steve's going to...

    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

    October 24, 2011 at 5:21 am

    #1398614

  • RE: CPU Utilization is 100%

    Ninja's_RGR'us (10/24/2011)

    Is lock pages in memory on? That will use everything available right on startup (up to the limit you set for the server).

    No matter the locked pages setting,...

    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

    October 24, 2011 at 4:50 am

    #1398595

  • RE: shrinkfile alternative

    balaji.ganga 68339 (10/24/2011)

    3. change the db into sinlge_user then change into multiuser, detach the database. remove the

    log file then attach the database with out 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

    October 24, 2011 at 4:43 am

    #1398592

  • RE: Need help to optimize my query

    This shouldn't lock the table unless you're processing the entire table. If you're processing a portion of the scan table and have predicates on indexed columns (the date should 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

    October 24, 2011 at 4:41 am

    #1398588

  • RE: Is moving or resizing templog without connecting to the database engine possible?

    Stop Reporting Services. Something (I assume SSRS) is grabbing the sole connection to the server, connecting to a user database and forcing SQL to start up that user database and...

    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

    October 24, 2011 at 4:03 am

    #1398570

  • RE: Are the posted questions getting worse?

    100% complete plagiarism.

    He's got guts. http://sqlserverboost.info/?p=185 is a copy of an MS whitepaper. That's messing with the big league.

    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

    October 24, 2011 at 3:35 am

    #1398562

  • RE: shrinkfile alternative

    SpringTownDBA (10/23/2011)

    You can disable non-clustered indexes, which frees up space, reducing the amount of data that needs moved in the shrinkfile.

    You'll almost certainly need to rebuild your indexes...

    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

    October 24, 2011 at 3:18 am

    #1398555

  • RE: Need help to optimize my query

    Did you test that the join was expensive? Yes, it's an inequality, but that doesn't automatically mean expensive.

    I tested your and my code on a million rows in #scan.

    Calendar table...

    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

    October 24, 2011 at 3:11 am

    #1398552

  • RE: Enable/Disable Trigger

    thulani.moyana 79207 (10/24/2011)

    I'm wondering why the single exec('Use database') does not affect the statement immediately after it as I would have thought it is executing on the target database but...

    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

    October 24, 2011 at 3:05 am

    #1398551

  • RE: PRINCIPAL SERVER goes in "In Recovery"

    It's unlikely to detach. Probably going to require something like stopping SQL, moving the files and then restarting SQL so that the DB comes up recovery pending and then restoring...

    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

    October 24, 2011 at 2:52 am

    #1398547

  • RE: Need help to optimize my query

    Awesome. Makes things so much easier when I can test a solution.

    First thing you need is a calendar table. I've created it as a # table, I recommend you create...

    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

    October 23, 2011 at 2:14 pm

    #1398478

  • RE: shrinkfile alternative

    nawillia (10/23/2011)

    I was thinking I could backup the database , drop the original, create a new db with the same name and new size, and then restore from the original...

    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

    October 23, 2011 at 12:29 pm

    #1398474

Viewing 15 posts - 22,756 through 22,770 (of 49,552 total)