Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 49,552 total)

  • RE: Read Write Deadlock

    kudz (1/29/2016)

    I tHought of swapping the text field by varchar max but won't work as I have rows with more than 4000 chars and that will be the same as...

    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

    January 30, 2016 at 1:51 am

    #1855453

  • RE: Facing problems with memory/cpu pressure because of multiple executions of the code

    ffarouqi (1/29/2016)

    In case if you do not mind me asking is there anything what we can do for these queries. Anything that can make this better.

    Exactly the same problem (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

    January 30, 2016 at 1:42 am

    #1855452

  • RE: How to do CASE WHEN THEN CASE

    You can, you're missing an END.

    CASE WHEN ISNULL(oa.IsRetail,odr. IsRetail) = 1 THEN

    ...

    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

    January 29, 2016 at 12:49 pm

    #1855359

  • RE: Read Write Deadlock

    kudz (1/29/2016)

    How do you guys would resolve this situation?

    Probably by using one of the row-versioning isolation levels, especially if I don't have code to work through.

    Do I have any...

    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

    January 29, 2016 at 12:40 pm

    #1855357

  • RE: Facing problems with memory/cpu pressure because of multiple executions of the code

    Since I wrote that article, it's already in my words.

    Skim the first section and read the second section. You can skip the rest of it for now. The second...

    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

    January 29, 2016 at 11:43 am

    #1855336

  • RE: Facing problems with memory/cpu pressure because of multiple executions of the code

    I guess you missed the link.

    GilaMonster (1/29/2016)

    See - https://www.simple-talk.com/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/

    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

    January 29, 2016 at 11:16 am

    #1855328

  • RE: The Most Common Query Blunders...

    Eirikur Eiriksson (1/29/2016)

    Jeff Moden (1/29/2016)

    GilaMonster (1/29/2016)

    Jeff Moden (1/28/2016)

    Rich Mechaber (1/5/2016)

    You've probably got more material than you need by this point. This one's an old article, but I still find...

    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

    January 29, 2016 at 10:27 am

    #1855311

  • RE: Facing problems with memory/cpu pressure because of multiple executions of the code

    Can you limit the table definitions to just the tables relevant to the query please, and include the index definitions.

    Problem 1:

    AND (@PickListGuid is NULL or PList.PickListGuid=@PickListGuid)

    AND (@ProjectGuid is NULL 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

    January 29, 2016 at 10:26 am

    #1855310

  • RE: Are the posted questions getting worse?

    BL0B_EATER (1/29/2016)

    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    A year ago I was...

    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

    January 29, 2016 at 10:22 am

    #1855308

  • RE: Reason for adding a new SQL Server instance in same machine

    William Rayer (1/29/2016)

    Actually I can think of another reason. Some 3rd party apps using SQL server expect their database login to be installed with sysadm rights, so you can limit...

    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

    January 29, 2016 at 10:04 am

    #1855299

  • RE: COMPATIBILTY LEVELS AFTER UPGRADE

    It is. SQL 2012 doesn't support compat more 80, so the restored database could not have been left in compat mode 80.

    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

    January 29, 2016 at 3:24 am

    #1855178

  • RE: The Most Common Query Blunders...

    Jeff Moden (1/28/2016)

    Rich Mechaber (1/5/2016)

    You've probably got more material than you need by this point. This one's an old article, but I still find it useful to refer people...

    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

    January 29, 2016 at 2:39 am

    #1855164

  • RE: SQL Server 2008 - DB troubleshooting - need peer review

    "(table2.[type]<2 and table2.[type]>2)"

    That will match precisely 0 rows, as type cannot be both less than 2 and greater than 2 at the same time. It's not equivalent to (table2.type !=...

    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

    January 29, 2016 at 2:27 am

    #1855162

  • RE: Deciding not to use a plan

    Could be a bunch of things

    The one that comes to mind looking at it is that the table isn't schema-qualified, hence SQL could think that different users = different objects...

    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

    January 29, 2016 at 2:16 am

    #1855161

  • RE: SQL 2014 Enterprise Edition

    Jeff Moden (1/28/2016)

    Markus (1/28/2016)

    That is the first release of SQL 2012.

    Look again. It's the RTM of 2014.

    We don't know what it is because the OP hasn't posted the build...

    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

    January 29, 2016 at 2:09 am

    #1855159

Viewing 15 posts - 3,721 through 3,735 (of 49,552 total)