Forum Replies Created

Viewing 15 posts - 346 through 360 (of 49,552 total)

  • RE: Index operation fails with below

    Is there a shrink database/shrink file running? Does the DB have autoshrink enabled? Is there another index operation running on that 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

    February 13, 2018 at 1:30 am

    #1979561

  • RE: What to Read in 2018

    jasona.work - Monday, February 12, 2018 12:07 PM

    GilaMonster - Friday, February 9, 2018 5:39 AM

    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

    February 12, 2018 at 2:01 pm

    #1979519

  • RE: Save off and put back stats in production

    SQLBastian - Monday, February 12, 2018 6:48 AM

    The more I have been looking into this the more it seems setting statistics back...

    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

    February 12, 2018 at 7:04 am

    #1979410

  • RE: SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2

    Patrick.I - Monday, February 12, 2018 4:50 AM

    Thanks for that but the main issue i have here is how to use...

    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

    February 12, 2018 at 5:31 am

    #1979404

  • RE: SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2

    There's a lot of things wrong with that, but the most obvious is that the FROM is not followed by a table or subquery. Looks like there's a SELECT missing.

    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

    February 12, 2018 at 4:35 am

    #1979400

  • RE: A Simple Introduction to Dynamic SQL

    julian.fletcher - Monday, February 12, 2018 2:16 AM

    You quite rightly say

    When placing your Dynamic SQL code into production (typically in stored...

    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

    February 12, 2018 at 4:31 am

    #1979399

  • RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

    pcd_au - Sunday, February 11, 2018 8:40 PM

    Performance improves significantly, but fragmentation levels are around the same.

    I'm at a loss to explain...

    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

    February 12, 2018 at 2:13 am

    #1979389

  • RE: Developer edition to standard edition

    Lynn Pettis - Friday, February 9, 2018 8:38 AM

    And if I remember correctly, you may have to uninstall and reinstall to get...

    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

    February 9, 2018 at 8:40 am

    #1979255

  • RE: Kill long running transactions

    Alexander Zhang - Thursday, February 8, 2018 11:06 PM

    Whenever we kill a session, first of all, we should be very carefully check...

    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

    February 9, 2018 at 8:38 am

    #1979253

  • RE: Developer edition to standard edition

    Keep in mind that Developer edition is not licensed for production usage. So by using it in prod, you're at risk of audits hitting you with a lot of fines.

    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

    February 9, 2018 at 8:36 am

    #1979251

  • RE: How im can backup DTS to restore in sql 2008?

    You can't. You'll have to rewrite it as an SSIS package.

    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

    February 9, 2018 at 6:10 am

    #1979226

  • RE: What to Read in 2018

    Thom A - Friday, February 9, 2018 6:01 AM

    I'm sure I recall the synopsis on the first book stating it 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

    February 9, 2018 at 6:08 am

    #1979224

  • RE: What to Read in 2018

    My plans for the year include the rest of the Expanse series, to try and make a dent in the unread Data and Machine Learning books I've bought, to read...

    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

    February 9, 2018 at 5:39 am

    #1979221

  • RE: What to Read in 2018

    Thom A - Friday, February 9, 2018 3:38 AM

     He released the 3rd book of the Stormlight "Trilogy" (because book 3 doesn't finish...

    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

    February 9, 2018 at 5:35 am

    #1979220

  • RE: Delete 5 lac records from table

    If there aren't too many foreign keys and the amount you're deleting is more than the amount of rows you want to keep, it may well be faster to insert...

    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

    February 9, 2018 at 5:29 am

    #1979219

Viewing 15 posts - 346 through 360 (of 49,552 total)