Forum Replies Created

Viewing 15 posts - 8,716 through 8,730 (of 49,552 total)

  • RE: Drop table rollback

    free_mascot (6/17/2014)

    Now in this case due to huge table before sql server create internal checkpoint commnad was cancelled in 30 min and it might have rollback completely.

    Nothing to do with...

    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 17, 2014 at 5:34 am

    #1722263

  • RE: How to see if a table alreay has a column

    river1 (6/17/2014)

    Can you show me the commands to do this?

    Koen already did.

    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 17, 2014 at 4:47 am

    #1722232

  • RE: Order of the result issue in T-SQL

    Easiest way will be to add another column, call it DisplayOrder or something like that. Populate that column with the order you want the rows to be displayed and ORDER...

    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 17, 2014 at 3:55 am

    #1722210

  • RE: CheckDB is failing

    Post the exact command you're running and the exact error you're getting.

    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 17, 2014 at 3:52 am

    #1722207

  • RE: The Last Line of Defense

    Simple, I make very, very sure that I'm not indispensable.

    I make sure that others can do the majority of what I do, doesn't have to be as efficiently...

    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 17, 2014 at 3:17 am

    #1722197

  • RE: Switching from Active\Passive to Active\Active

    To be honest, there's no such thing as an active-passive or active-active cluster. There's a cluster and it can have 1 or more instances of SQL installed on it.

    What tends...

    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 17, 2014 at 3:02 am

    #1722194

  • RE: Getting rid of sysadmin role for application

    Could you identify what command the app is running when it throws that error? Use a server-side trace if necessary.

    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 17, 2014 at 2:56 am

    #1722192

  • RE: Dead Lock Help..

    And for some general info - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    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 15, 2014 at 2:46 pm

    #1721814

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/14/2014)

    GilaMonster (6/14/2014)

    Koen Verbeeck (6/14/2014)

    Ah, the world cup...

    Yup, that's pretty much how I feel.

    I have little interest in sport. Most of the time that's fine. This week, I...

    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 14, 2014 at 12:00 pm

    #1721757

  • RE: Covering Index Issue

    itsgaurav (6/14/2014)

    And I include this in my index as mentioned above question.

    Then it will reduce performance of my sql or not.

    ...

    To be honest, unless the description tends to 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

    June 14, 2014 at 11:58 am

    #1721756

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (6/14/2014)

    Ah, the world cup...

    Yup, that's pretty much how I feel.

    I have little interest in sport. Most of the time that's fine. This week, I can't even go 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

    June 14, 2014 at 6:52 am

    #1721743

  • RE: Corruption Detected

    Repair is not recommended, do you have a clean backup?

    You have a corrupt database, therefore you need to check hardware, IO subsystem specifically. The specific errors that checkDB throws aren'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 13, 2014 at 1:07 pm

    #1721643

  • RE: Removing joins & Execution Time

    Probably because the joins weren't the limiting factor of the query's performance. Hard to say much more in general terms.

    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 13, 2014 at 12:58 pm

    #1721640

  • RE: Are the posted questions getting worse?

    I hate soccer season.

    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 13, 2014 at 12:26 pm

    #1721627

  • RE: Corruption Detected

    Ideally, restore from a clean backup.

    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 13, 2014 at 9:48 am

    #1721533

Viewing 15 posts - 8,716 through 8,730 (of 49,552 total)