Forum Replies Created

Viewing 15 posts - 14,386 through 14,400 (of 49,552 total)

  • RE: Log Shipping Simple question re: full backup involvement

    Doesn't affect the log shipping at all. The only time a full backup needs to be copied is when the log shipping's broken and needs to be reset, even 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

    February 6, 2013 at 9:35 am

    #1585023

  • RE: Record locking

    JohnPapa (2/6/2013)

    In the recordset the RV value is not Null, nothing prints when you try to print the value and the field is empty on the form. I will look...

    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 6, 2013 at 9:27 am

    #1585019

  • RE: Do you really need the log file

    mike 57299 (2/6/2013)

    A full backup doesn't set the log to re-usable?

    No.

    Please read through this - Managing Transaction Logs[/url]

    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 6, 2013 at 9:24 am

    #1585017

  • RE: Record locking

    Again, don't display it. There's absolutely no value in what it looks like and if all you need to do is compare it, it does not need to be displayed.

    Have...

    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 6, 2013 at 8:13 am

    #1584966

  • RE: Cannot obtain LOCK resource at this time :sick:

    SQL Pizza (2/6/2013)

    The developers use NOLOCK AND ROWLOCK.

    There's a good chance that's a contributing factor (the rowlock usage)

    Why snapshot isolation allowed and still using nolock hints? All the downsides 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 6, 2013 at 7:09 am

    #1584940

  • RE: Record locking

    Ok, so read it from the recordset into a variable (or leave it in the recordset) and compare when you're going to do the update.

    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 6, 2013 at 6:59 am

    #1584932

  • RE: Cannot obtain LOCK resource at this time :sick:

    Have you got any of the lock escalation traceflags turned on? Are you using any locking hints?

    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 6, 2013 at 6:51 am

    #1584929

  • RE: How to take backup & restore for one table?

    5 year old thread. Please post new questions in a new thread. Thanks

    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 6, 2013 at 6:50 am

    #1584928

  • RE: What is Index key Value in SQL SERVER 2005

    Indexing:

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    When you create an index, the column or set of columns that the index is created on is the key columns.

    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 6, 2013 at 6:50 am

    #1584926

  • RE: Record locking

    In the stored procedure that does your updates. In the VB code. Up to you.

    There's no point at all in displaying it though, no user's going to understand the meaning...

    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 6, 2013 at 6:41 am

    #1584921

  • RE: Performance Issue - understanding query plans

    nick.mcdermaid (2/6/2013)

    Can anyone recall if they have run into an issue like that before? SQL incorrectly estimates a very large result set (almost a cross join) when in fact 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 6, 2013 at 3:08 am

    #1584820

  • RE: Performance Issue - understanding query plans

    nick.mcdermaid (2/6/2013)

    p.s. The plan that comes from sys.dm_exec_query_plan is the estimated plan, because it has no actual row counts.

    Are you saying that actual plans are not in that table?

    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

    February 6, 2013 at 2:43 am

    #1584809

  • RE: Record locking

    I'm not a VB programmer. Why would you want to display it anyway? It's a binary value, meaningless to any user.

    btw...

    &...

    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 6, 2013 at 2:29 am

    #1584801

  • RE: Performance Issue - understanding query plans

    nick.mcdermaid (2/6/2013)

    OK I extracted what I think is the actual plan from sys.dm_exec_query_plan and it was identical to the estimated one that I uploaded, so we can assume the uploaded...

    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 6, 2013 at 2:27 am

    #1584800

  • RE: Help on sys.dm_db_index_physical_stats

    Huh? Don't understand the question.

    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 6, 2013 at 2:22 am

    #1584799

Viewing 15 posts - 14,386 through 14,400 (of 49,552 total)