Mecanics behind a Transaction (COMMIT/Rollback)

Anyone can point me a document that explain the mecanics
used by SQL Server to perform a transaction (i.e: Begin
Transaction -- Commit or Rollback Transaction).
I would like to know which tables are used to do so and
all the details.
Regards,Basic priciple is that all are updates are written to log file before =being written to the db. Once the transaction commits an entry is made =in the log recording that fact. If the system should fail, then on arestart the log is examined (from =the most recemt checkpoint) and any transactions that have been =committed since that checkpoint are written to the db. any db pages for =transactions that were open (uncommittted) at the point of failure will =be unwound from the db by re-applying the before-image values from the =log.
The idea of a checkpoint is a marker in the log that records the facet =that all "dirty" pages in cache (ie those that have been updated) are =flushed back to disk, so the information in the log is guaranteed =consistent at the tme a checkpoint is taken. These days checkpoint =intervals are automatically tuned by SQl serever and normally are fine.
That's the short version. Inside SQL Server 2000 by Kalen Delaney has =loads more. Or Microsoft 2072 course also covers all of this.
Mike John
"Roger Dion" <RogerRKDDion@.Roditek.com> wrote in message =news:0fe701c351f8$c42febc0$a001280a@.phx.gbl...
> Anyone can point me a document that explain the mecanics > used by SQL Server to perform a transaction (i.e: Begin > Transaction -- Commit or Rollback Transaction).
> > I would like to know which tables are used to do so and > all the details.
> > Regards,
> >=20

MDX Lag and Font use

Hi all,
I have a cube with a Year Dimension and Month dimension (wanted
intersections).
Does anyone have a calc-cell example that would perform something akin to
the following.
If (Current month sales - Last Month Sales)/Current month sales >15% then
cell font color bold and green, else if (Current month sales - Last Month
Sales)/Current month sales <20% then cell font color bold and red, else
default.
Thanks in advance.Here's an example for Foodmart Sales cube:
[vbcol=seagreen]
With
Member [Measures].[SalesTrend]
as '([Measures].[Unit Sales]
- ([Measures].[Unit Sales], [Time].PrevMember))
/[Measures].[Unit Sales]',
FORMAT_STRING = 'Percent'
Cell Calculation [SalesFormat]
for '({[Measures].[Unit Sales]}, {[Time].[Month].M
embers})'
as 'CalculationPassValue([Measures].[Unit Sales], -1, RELATIVE)',
FORE_COLOR = 'iif([Measures].[SalesTrend] > 0.15,
rgb(0,128,0), iif([Measures].[SalesTrend] < -0.20,
rgb(255,0,0), rgb(0,0,0)))',
FONT_FLAGS = 'iif([Measures].[SalesTrend] > 0.15
Or [Measures].[SalesTrend] < -0.20, 1, 0)'
Select {[Measures].[Unit Sales], [Measures].[SalesTrend
]} on columns,
Descendants([Time].[1997], [Time].[Month]) on rows
from Sales[vbcol=seagreen]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!