Serge Rielau wrote:
>> What any and all financial systems require is the ability to produce a
>> result set consistent to a point-in-time ... preferably without locking
>> tables. Something impossible to do with previous versions of SQL Server.
>
> That's what timestamps are there for. You rarely need to see the whole
> database in snapshot mode. If you want to sum the POS data up for the
> day a simple WHERE clause will do.
> To solve concurency issues READ COMMITTED IMHO is plenty good.
> Anything beyond that is 99% religion, 1% actual requirement.
>
> Cheers
> Serge
Which somehow explains why even Microsoft doesn't use its own technology
under its SAP financial system: Right?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Feb 21 2006 - 11:22:59 CST
