Hi Aaron,

Sorry about the confusion. I was generalizing perhaps a bit too much. You are correct in your belief that the size of the transaction log should not create...

Aaron Sentell (10/28/2007)

---

We have a database with a 2 GB transaction log that is a publisher for non-updateable transactional replication. This database resides on a SQL 2000 EE Server SP4...

The bookmark lookup happens when the qurey processor uses an index to find the...

Seconded. I can imagine too many scenarios where the hit ratio might...

You can certainly get away with using RAID 5 for your data files. I've done it in the past, and have not come across a situation where there was...

Another good trick for cursors:

Declare cursor foo....

Declare @someVariable INT

open foo

While (1=1)

BEGIN

Fetch foo into @someVariable

IF @@Fetch_Status <> 0 BREAK -- no more data

--do something here

END

This eliminates the need for two...

I'm not pointing out anything other than the fact that the order in which the rows are added changes the result, thus suggesting that addition of floats is not associative....

I just tried a little experiment myself:

create table foo (

ID int identity,

X float)

set nocount on

declare @ctr int

select @ctr = 0

while @ctr < 1000

BEGIN

insert foo (X)

select rand()

select @ctr= @ctr +...

Colin,

One more question. Can you attempt the float sum again, but this time specify the ordering of the rows? I ask because an unconfirmed source (wikipedia) seems...

Hi Colin,

Are there any differences in CPU, O/S, or SQL build between the two boxes?

I've seen a financial system that used floats as surrogate primary keys. I'm not sure what was going on there, but I assume that the database was converted...

The backup extension doesn't matter to SQL server, but it might matter to your hosting company's SQL server interface.

You can try renaming the backup file so that is has...

So, Bob, should we buy or should we sell?

Hello,

I've never done this. All of my transactional publications are not partitioned. There should be a way to do what you want, but I'm not sure how involved...

The procedure is sp_scriptdynamicupdproc. not ...updateproc.