Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 49,552 total)

  • RE: Let the optimizer do it's thing -- wrong

    Alan.B (12/9/2016)

    Indianrock (12/9/2016)

    I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart so don't use plan guides, query...

    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

    December 11, 2016 at 2:14 pm

    #1917286

  • RE: Let the optimizer do it's thing -- wrong

    Indianrock (12/9/2016)

    "It’s not using new stuff because of FORCED parameterization because it caches the plan and reuses it. If you keep it SIMPLE, I think it would use the new...

    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

    December 11, 2016 at 2:08 pm

    #1917285

  • RE: 16 core and sql server enterprise license cost

    nal4236 (12/3/2016)

    SQL Enterprise licenses are only sold in the 2-core "pack", essentially what I'm referring to as a "single SQL Enterprise license" since you do not have the option...

    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

    December 3, 2016 at 5:33 am

    #1915881

  • RE: Sql transaction question

    KGJ-Dev (12/2/2016)

    Will either one satisfy my need?

    Test carefully and see, and make sure you read up on them

    which one is the best for my situation

    Test carefully and 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

    December 2, 2016 at 11:46 pm

    #1915878

  • RE: 16 core and sql server enterprise license cost

    nal4236 (12/2/2016)

    One license = one core. 16 cores, 16 licenses.

    Incorrect. You can only buy licenses in packs of two.

    Indeed you can only buy licenses in packs of two, as my...

    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

    December 2, 2016 at 11:45 pm

    #1915877

  • RE: Sql transaction question

    Read committed snapshot or snapshot isolation?

    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

    December 2, 2016 at 2:05 pm

    #1915835

  • RE: Login triggers - some general questions...

    You probably want a

    WITH EXECUTE AS

    on that proc for the insert into a table in master.

    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

    December 2, 2016 at 2:02 pm

    #1915833

  • RE: Sql transaction question

    KGJ-Dev (12/2/2016)

    I have used transaction because if anything fails i don't want to commit it.

    Do you have proper error handling that will rollback in case of an error?

    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

    December 2, 2016 at 2:00 pm

    #1915832

  • RE: Upgrading to 2016 - pros, cons, planning

    I haven't specifically tested those, but there are no changes I know of to fix them in 2016. Stick with OPTION(RECOMPILE) on them.

    From 2014 it should be a safe upgrade.

    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

    December 2, 2016 at 6:32 am

    #1915695

  • RE: Upgrading to 2016 - pros, cons, planning

    Not an article, but...

    Query Store is probably the killer feature. It makes it trivial to monitor performance, track query plans, etc.

    The "It just runs faster" series of posts on 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

    December 2, 2016 at 5:28 am

    #1915672

  • RE: To much (early) blocking.

    ben.brugman (12/2/2016)

    The marbles (see reference) example is simple and very good.

    Except that it won't show isolation level differences except for lock-based vs rowversion-based, because they're data modifications and hence 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

    December 2, 2016 at 2:49 am

    #1915642

  • RE: 16 core and sql server enterprise license cost

    nal4236 (12/1/2016)

    Yes, you need enough SQL Enterprise licenses to cover all 16 cores, however one SQL Enterprise license = 2 cores. So for a 16-core server you'll need a total...

    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

    December 2, 2016 at 1:14 am

    #1915625

  • RE: How to drop temp table created by somebody else?

    JP10 (12/1/2016)

    Just created a tmp table and ran the query that looks at the default traces and nothing comes up for temp tables.

    Temp tables are logged in the default...

    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

    December 1, 2016 at 11:46 am

    #1915537

  • RE: To much (early) blocking.

    They're not hard to do.

    Multiple identical selects in a transaction (maybe with a waitfor between them) and updates, inserts and deletes running from elsewhere that would affect rows returned by...

    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

    December 1, 2016 at 8:42 am

    #1915445

  • RE: Are the posted questions getting worse?

    2005 can be *restored* to anything above it.

    The two-version limit is in-place upgrades afaik. Restores there's no such limit (as long as you're not dealing with a SQL 2000 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

    December 1, 2016 at 8:27 am

    #1915433

Viewing 15 posts - 2,011 through 2,025 (of 49,552 total)