anyone use this as their Backup plan?

Wait a sec.....

BOL:

"Because SQL Server must wait for the disk subsystem to complete I/O to SQL Server log files as each transaction is completed, it is important that the disks...

sounds right to me.

Thanks.

so any data page change never goes from the data buffer cache to disk???

So the changes get written to the log cache, then to the log file on disk, then...

So if a data page is pulled into cache and then changes are made to that data page while in cache, that page is considered "dirty". With that same change,...

ya all my calls are Stored Procedures.

so if a full Table resides in Buffer Cache and the Optimizer does a full table scan for example, the results will be a Logical Read only - and...

Why just logical reads?

yes. Thats fine then.

What other things should I be looking at here?

(What I am doing is running queries to determine where to place indexes.)

So how can I force a Physical Read?

Yes that is what I expect to see. However, below is what I am seeing. Now this table has no Primary Key and no Clustered Index on it(for testing purposes)....

I haven't had a change to try this yet.

Any experiences anyone?

how are you testing this?

I want to find out what size specific rows are. Meaning what amount of data is in there.

Andy,

What is the difference between the stripe set and cluster size?