Forum Replies Created

Viewing 15 posts - 6,571 through 6,585 (of 49,552 total)

  • RE: Help!!!

    somubhandaru23 (2/11/2015)

    You have performed a large insertion and/or deletion, or you may have bulk inserted some sufficiently large data that is causing sql server to return a wrong query plan....

    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 11, 2015 at 9:55 am

    #1776995

  • RE: IMprove performance

    Table definitions, index definitions and execution plan please.

    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 11, 2015 at 9:12 am

    #1776982

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (2/11/2015)

    It is amazing the lengths people will go to to avoid making a simple change.

    All they had to do was change LEFT OUTER LOOP JOIN to LEFT JOIN,...

    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 11, 2015 at 8:37 am

    #1776966

  • RE: Are the posted questions getting worse?

    Rather hot here, was 34 C around midday, scheduled blackouts in suburb containing office means no aircon.

    Need: Ice-cold shower.

    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 11, 2015 at 8:29 am

    #1776958

  • RE: How to kill current queries taking most cpu.

    Sean Lange (2/11/2015)

    admin 31599 (2/11/2015)

    --Current queries

    SELECT

    r.session_id,

    s.TEXT,

    r.[status],

    r.blocking_session_id,

    r.cpu_time,

    r.total_elapsed_time

    FROM sys.dm_exec_requests r

    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s

    Find blocking_session_id or heavy one and then

    kill #

    If using this script very often the next step is...

    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 11, 2015 at 8:21 am

    #1776949

  • RE: Will order of fields create any performance issues?

    below86 (2/11/2015)

    When I've looked at indexes for some tables I have eeven seen the same fields in the index, but in a different order. Like one where it has...

    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 11, 2015 at 8:20 am

    #1776948

  • RE: Backup Jobs on Availability Groups

    You can't run a non-copy_only backup on anything other than the primary replica. Only copy_only backups (and log backups) can be run on the preferred replica.

    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 11, 2015 at 7:35 am

    #1776935

  • RE: Will order of fields create any performance issues?

    below86 (2/11/2015)

    GilaMonster (2/11/2015)

    below86 (2/10/2015)

    I know when listing the fields in your joins in the same way the index is created has always made a difference

    It does not. Nor does 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

    February 11, 2015 at 7:34 am

    #1776934

  • RE: Backing up Alternatives

    While it's possible to export data (look up BCP), SQL Server doesn't script databases as a backup.

    SQL's backups are more efficient than scripts of the DB would be. Could you...

    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 11, 2015 at 5:46 am

    #1776889

  • RE: Copy Resource database MDF for Upgrading

    No, it won't.

    BoL is talking about as part of a patch, the patch installation process can just replace the resource DB with an updated one instead of having to run...

    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 11, 2015 at 5:16 am

    #1776884

  • RE: How to kill current queries taking most cpu.

    Joy Smith San (2/9/2015)

    Yes, I am clear on that part. I am planning to give them rights to find and kill their queries

    You do realise that to do so...

    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 11, 2015 at 12:50 am

    #1776837

  • RE: Configuring min memory per query option and index create memory option

    I've seen systems like that. They're usually a mess because *someone* has been fiddling with things that they probably don't understand.

    I've never changed either, when I do find them changed...

    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 11, 2015 at 12:48 am

    #1776836

  • RE: Will order of fields create any performance issues?

    below86 (2/10/2015)

    I know when listing the fields in your joins in the same way the index is created has always made a difference

    It does not. Nor does the order of...

    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 11, 2015 at 12:46 am

    #1776833

  • RE: Append differential backup

    1 backup per file, with the datetime as part of the file name, and don't use backup devices.

    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 11, 2015 at 12:40 am

    #1776828

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/10/2015)

    So, Boston Threadzians... Wanna Fedex some snow down to Florida for me?

    I could use some too. Enough to fill a swimming pool. It's seriously hot here at 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

    February 10, 2015 at 5:38 am

    #1776590

Viewing 15 posts - 6,571 through 6,585 (of 49,552 total)