Forum Replies Created

Viewing 15 posts - 23,266 through 23,280 (of 49,552 total)

  • RE: Profiler and execution plan giving different results

    The costs are estimates. They are generated at compile time based on estimated row counts and there are many, many ways for them to be wrong (stale statistics, parameter sniffing,...

    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

    September 27, 2011 at 3:25 am

    #1386994

  • RE: Are the posted questions getting worse?

    ALZDBA (9/27/2011)

    GilaMonster (9/26/2011)

    ALZDBA (9/26/2011)

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db 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

    September 27, 2011 at 3:16 am

    #1386989

  • RE: What threshold value is optimal for index rebuild ?

    SQL Guy 1 (9/26/2011)

    The previous poster, instead of giving some meaningful numbers, sarcastically asked if I "reinvent the wheel ?".

    There was no sarcasm whatsoever in my statement, and 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

    September 27, 2011 at 3:02 am

    #1386987

  • RE: Are the posted questions getting worse?

    ALZDBA (9/26/2011)

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db to be flushed ?

    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

    September 26, 2011 at 3:12 pm

    #1386843

  • RE: Best option to perform an update without transaction log growth

    Untested. Test it yourself first!!!!!

    DECLARE @Done bit;

    SET @Done = 0;

    WHILE (@Done = 0)

    BEGIN

    UPDATE TOP (X) Product

    SET Productid...

    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

    September 26, 2011 at 2:43 pm

    #1386820

  • RE: add snapshot Isolation for ad-hoc queries

    Yes you can, providing snapshot isolation has been enabled on the database level first.

    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

    September 26, 2011 at 2:38 pm

    #1386818

  • RE: Are the posted questions getting worse?

    For those who are interested, SQL Server MVP Deep Dives 2 is now available for pre-order and MEAP (early access to some chapters) and will be launched during PASS Summit.

    http://www.manning.com/delaney/

    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

    September 26, 2011 at 2:33 pm

    #1386815

  • RE: Best option to perform an update without transaction log growth

    Can you post the current update statement? Will there be an easy way to tell an updated from from one not yet updated?

    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

    September 26, 2011 at 2:24 pm

    #1386806

  • RE: add snapshot Isolation for ad-hoc queries

    Providing snapshot isolation has been enabled on the database, yes. Do watch the additional load on TempDB

    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

    September 26, 2011 at 2:20 pm

    #1386802

  • RE: What threshold value is optimal for index rebuild ?

    SQL Guy 1 (9/26/2011)

    Thanks, Jessie. Finally I got some meaningful numbers to start with.

    I take it you either didn't follow or ignored the links I posted?

    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

    September 26, 2011 at 2:08 pm

    #1386790

  • RE: Backup = Error Msg 3271, Level 16, State 1

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1181257-357-1.aspx

    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

    September 26, 2011 at 12:50 pm

    #1386747

  • RE: Bypassing SQL 2008 straight to 2011.....? Thoughts....?

    Just btw, it's not SQL Server 2011. There's been no name picked for it yet. Code name is Denali. It's been called SQL 11 because the major version number (select...

    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

    September 26, 2011 at 12:40 pm

    #1386740

  • RE: Two Node Cluster Performance Improvement over single server ?

    Well, syntax errors aside, I said temp tables and you're using permanent tables. That's going to give you some fun race-conditions and incorrect results if 2 people run this at...

    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

    September 26, 2011 at 12:37 pm

    #1386737

  • RE: What threshold value is optimal for index rebuild ?

    SQL Guy 1 (9/26/2011)

    The script to optimize indexes by Ola Hallengren that you are reffering here, is extremely huge, it was written for like "one-size-fits-all". It would take me...

    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

    September 26, 2011 at 12:10 pm

    #1386719

  • RE: An unusual approach to backups

    You have up to an hour's data loss in any disaster and the transaction log is going to be many times the size it probably should be. If no one...

    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

    September 26, 2011 at 11:45 am

    #1386702

Viewing 15 posts - 23,266 through 23,280 (of 49,552 total)