Forum Replies Created

Viewing 15 posts - 1,741 through 1,755 (of 49,552 total)

  • RE: Key Lookup to Index Seek?

    Can you post the plan please (as a .sqlplan file)

    A key lookup is Always to the clustered index. It cannot be to any other index. A key lookup...

    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 22, 2017 at 12:38 pm

    #1929821

  • RE: Repeatble Read Isolation level

    The first statement is the same as the behaviour in read committed. Session one starts a transaction, updates a row. Session 2, in read committed or repeatable read cannot 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 22, 2017 at 9:58 am

    #1929777

  • RE: Are the posted questions getting worse?

    Nothing like listening to the developers sitting 2 rows behind me spend half an hour trying to figure out what max server memory should be, and not come and ask...

    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 22, 2017 at 8:27 am

    #1929743

  • RE: how to use throw in following situation.

    It works as written, and is correct (except for the missing commit tran/rollback tran). In this case the SSMS intellisense is incorrectly flagging a lack of 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

    February 22, 2017 at 6:33 am

    #1929695

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, February 22, 2017 6:23 AM

    It's the same thing if a man wants to do something like daycare or...

    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 22, 2017 at 6:30 am

    #1929694

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, February 22, 2017 5:48 AM

    C)  THEN they may feel (rightly or wrongly) that they're being expected to meet 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

    February 22, 2017 at 6:06 am

    #1929684

  • RE: Restore Recovered Database ?!! Please Help!!!!!

    If the backup is damaged enough that SQL's throwing a media family error, the backup is likely to be garbage and unusable, and there's no magic 'fix backup' command that...

    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 22, 2017 at 5:06 am

    #1929676

  • RE: Are the posted questions getting worse?

    The "terms of use" (link at bottom of web page)

    8.1 We may, in our absolute discretion:

    (a) block you from using the Site where we...

    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 22, 2017 at 4:33 am

    #1929672

  • RE: Restore Recovered Database ?!! Please Help!!!!!

    You probably can't.  If the backup's damaged to the point you're getting that error then it's likely to be unusable.
    The other possibility is that you're trying to restore 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

    February 22, 2017 at 2:57 am

    #1929666

  • RE: Restore Recovered Database ?!! Please Help!!!!!

    If you're getting that error, the backup is probably damaged and not restorable.

    No backups of your 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

    February 22, 2017 at 12:30 am

    #1929647

  • RE: Are the posted questions getting worse?

    JustMarie - Tuesday, February 21, 2017 2:09 PM

    Half of me wants to figure out how to block him so I never see...

    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 21, 2017 at 2:59 pm

    #1929625

  • RE: How to avoid cursors

    scarr030 - Tuesday, February 21, 2017 9:08 AM

    Fair enough. Just out of curiosity, anyway: is there a way to do what I'm...

    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 21, 2017 at 9:17 am

    #1929546

  • RE: Optimizing a query

    Luis Cazares - Tuesday, February 21, 2017 6:01 AM

    If I'm correct, the number of locks would be the same. The only...

    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 21, 2017 at 6:08 am

    #1929500

  • RE: SQL error logs filling up

    You need to investigate why the client machine (the IP address you blanked out) is trying to connect to the wrong server. This isn't something that can be fixed on...

    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 21, 2017 at 6:03 am

    #1929498

  • RE: Optimizing a query

    JKSQL - Monday, February 20, 2017 1:06 PM

    The Nolocks is how they want views written for reports so there are less...

    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 21, 2017 at 1:37 am

    #1929472

Viewing 15 posts - 1,741 through 1,755 (of 49,552 total)