Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Mirrored Backups

    Good article, great feature with a fatal flaw!

    We've been using DeltaCopy http://www.aboutmyip.com/AboutMyXApp/DeltaCopy.jsp to mirror backups.  It's particularly good for WAN backups if not much has changed as it uses very...

  • RE: Question of the Day for 30 Mar 2005

    I'm sorry Adam but your understanding of locking is very poor.  What exactly does "SQL Server MVP" mean? 

    All reads in SQL server use shared locks, if they didn't you...

  • RE: Question of the Day for 30 Mar 2005

    I don't know what definition of optimistic/pessimistic you are using but everyone I've met uses the one below.

    Optimistic:

    Read record

    Work out what to do with it

    Lock record exclusively

    Update record

    Release...

  • RE: Question of the Day for 30 Mar 2005

    Another misleading question!

    "Prior to SQL Server 2005, SQL Server worked on a pessimistic concurrency model, locking data while it was being read to ensure consistency"

    This was only true in Repeatable...

  • RE: Optimizing Your Application - Part 2

    The Dataset class is designed to cache data.  Why create another structure to hold multiple datasets each with one table, when you can create one dataset with multiple tables? 

     

  • RE: Optimize Your Applications

    Why aren't you using System.Web.Caching.Cache?  That way you can control the latency.

Viewing 6 posts - 1 through 6 (of 6 total)