Forum Replies Created

Viewing 15 posts - 25,006 through 25,020 (of 49,552 total)

  • RE: Stored Procedure takes to long on website

    Very likely the different SET options between ASP.NET and SSMS result in different execution plans, one of which is efficient and one not.

    Get the actual execution plan from SSMS and...

    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

    July 9, 2011 at 12:31 pm

    #1350748

  • RE: Members of BUILTIN\Administrators not automatically members sysadmin?

    http://msdn.microsoft.com/en-us/library/cc280562%28v=SQL.100%29.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

    July 9, 2011 at 12:28 pm

    #1350747

  • RE: Migrating sql server logins

    Alright, so which was the final one you used, that actually created these logins?

    Have you checked the SQL error log for the reason why the logins are failing?

    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

    July 9, 2011 at 12:10 pm

    #1350745

  • RE: Migrating sql server logins

    How did you migrate the logins?

    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

    July 9, 2011 at 11:05 am

    #1350739

  • RE: Delete Query and 'Transaction Log is full' Error

    LutzM (7/9/2011)

    I'm definitely not going to argue with you Gail, but wouldn't horizontal partitioning with a Sliding Window be an option to consider?

    Yes, the thing it it's Enterprise only and...

    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

    July 9, 2011 at 7:42 am

    #1350732

  • RE: Same statements, different plans?

    Jeff Moden (7/9/2011)

    opc.three (7/8/2011)

    Long term I definitely want to remove the local variable swapping I just added.

    Why? :blink: It works just fine the way you did it and it's...

    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

    July 9, 2011 at 6:09 am

    #1350727

  • RE: Delete Query and 'Transaction Log is full' Error

    dso808 (7/8/2011)

    UGH!!! Sorry Gail - messed up my question (in a most embarassing way). I meant, should I CHANGE the restriction on the log size? In other...

    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

    July 9, 2011 at 3:21 am

    #1350715

  • RE: Space Management - why won't DBCC Shrinkfile work?

    steve smith-401573 (7/8/2011)

    GThe problem with the the logfile growth was a lack of backups being taken for over 4 months of growth -

    In that case you do want 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

    July 9, 2011 at 3:19 am

    #1350714

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/8/2011)

    GilaMonster (7/8/2011)

    Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.

    Monday's article: Why some...

    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

    July 8, 2011 at 3:03 pm

    #1350663

  • RE: High Safety W/O Automatic Failover (Synchronous)

    Jonathan Marshall (7/8/2011)

    If it has to be forced then there is possible data loss.

    You have to force it, but in synchronous mirroring (because transactions are committed on both sides before...

    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

    July 8, 2011 at 1:58 pm

    #1350638

  • RE: Memory pressure

    george sibbald (7/8/2011)

    I think the article you are referring to is a CSS blog which can be accessed via the URL I posted in my earlier reply in this thread....

    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

    July 8, 2011 at 1:53 pm

    #1350634

  • RE: Memory pressure

    That's 32-bit. Hence it needs AWE or it can only address 4GB.

    A 32-bit process needs AWE to address memory above the 4GB boundary

    A 64-bit process can address memory up...

    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

    July 8, 2011 at 1:29 pm

    #1350614

  • RE: Space Management - why won't DBCC Shrinkfile work?

    JamesMorrison (7/8/2011)

    I have done this many times without any problem. If you are having an issue, it is likely the exception, not the norm.

    It is a well documented process 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

    July 8, 2011 at 1:10 pm

    #1350605

  • RE: Space Management - why won't DBCC Shrinkfile work?

    JamesMorrison (7/8/2011)

    GilaMonster (7/8/2011)

    Unless the log grew very large as a product of some unusual operation, the size that it is is the size it needs to be for regular operation....

    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

    July 8, 2011 at 1:07 pm

    #1350604

  • RE: Memory pressure

    AWE is ignored completely on 64-bit.

    Locked pages has a use on both, but it is not related to memory addressability.

    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

    July 8, 2011 at 12:25 pm

    #1350575

Viewing 15 posts - 25,006 through 25,020 (of 49,552 total)