Forum Replies Created

Viewing 15 posts - 39,886 through 39,900 (of 49,552 total)

  • RE: recover a database that has been restored

    prabha (4/8/2009)

    As I said I want to recover the database before the last restore has been done.Any way whatever it may be

    So you're asking to recover data that has not...

    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

    April 8, 2009 at 6:38 am

    #974219

  • RE: Falling Over our Assumptions

    paul.gregory (4/8/2009)

    Not sure I agree with "'Get something up and running. We can always tidy it up later' "

    You should always plan to have to tune/improve some parts of 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

    April 8, 2009 at 3:29 am

    #974101

  • RE: Falling Over our Assumptions

    My favourite must be the assumption that data volumes don't matter. Usually uncovered when I speak to a developer about the performance of their code. The frequent litany it 'but...

    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

    April 8, 2009 at 3:16 am

    #974096

  • RE: Decryption errors on log shipping secondary - SQL Server 2005

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic692609-1291-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

    April 8, 2009 at 1:33 am

    #974050

  • RE: Procedure cache, Plan cache, Buffer cache

    The procedure cache and the plan cache are the same thing. Two different names. It was called the procedure cache in SQL 2000 and before because mainly it would contain...

    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

    April 8, 2009 at 1:32 am

    #974049

  • RE: Time out occurred while waiting for buffer latch

    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

    April 8, 2009 at 1:24 am

    #974047

  • RE: Verify my current backup strategy n suggest

    Michael Valentine Jones (4/7/2009)

    Any backup strategy that does not include getting your database backups to tape is incomplete and a disaster waiting to happen.

    Absolutely, 100% agree. Tape or somewhere else,...

    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

    April 8, 2009 at 1:16 am

    #974045

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/7/2009)

    Actually... I don't believe you have to be an MVP to nominate someone. I think anyone can do it. The more, the merrier.

    Anyone can, though...

    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

    April 8, 2009 at 1:14 am

    #974044

  • RE: dbcc freeproccache question

    DBA (4/7/2009)

    thank you all for your input, i am trying to do this because i was having issues with a stored procedure with parameter sniffing. I solved the problem...

    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

    April 8, 2009 at 1:04 am

    #974041

  • RE: Just Walk Away - Blacklisting - and Twits without Twitter

    Steve Jones - Editor (4/7/2009)

    GilaMonster (4/7/2009)

    Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' for 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

    April 8, 2009 at 1:02 am

    #974040

  • RE: Verify my current backup strategy n suggest

    Sudiendra (4/7/2009)

    Differential Backup - Every day and Retention Period - 1 day (Until the next Diff backup)

    Full Backup - Every week and Retention Period - 1 week (Till next full...

    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

    April 7, 2009 at 3:53 pm

    #973866

  • RE: dbcc freeproccache question

    Ken Simmons (4/7/2009)

    You would have to clear it for each plan handle that had the table name in the plan.

    That feature was only added in SQL 2008. In SQL 2005,...

    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

    April 7, 2009 at 3:45 pm

    #973861

  • RE: dbcc freeproccache question

    run sp_recompile and pass it the table name as a parameter. This will mark all plans based on that table as invalid and force them to recompile the next time...

    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

    April 7, 2009 at 3:42 pm

    #973858

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/7/2009)

    Cancel that. It did work. Thanks again.

    Pleasure

    How do I give you points.

    You don't. Points on this forum are given 1 for each post that a person...

    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

    April 7, 2009 at 1:25 pm

    #973747

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/7/2009)

    and despite the fact that someone called my code B.R.A.B, or B.A.B.S, or B.U.R.P

    RBAR = Row by agonising row. The point being that SQL is a set-based language...

    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

    April 7, 2009 at 1:22 pm

    #973743

Viewing 15 posts - 39,886 through 39,900 (of 49,552 total)