Viewing 6 posts - 1 through 6 (of 6 total)
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...
June 12, 2007 at 6:54 am
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...
March 31, 2005 at 11:17 am
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...
March 31, 2005 at 10:26 am
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...
March 31, 2005 at 2:54 am
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?
February 25, 2005 at 4:40 am
Why aren't you using System.Web.Caching.Cache? That way you can control the latency.
February 10, 2005 at 3:42 am
Viewing 6 posts - 1 through 6 (of 6 total)