Jeff Moden (6/15/2008)

---

Um... nope... a single update will update any given value once...

oops - I knew I forgot to post something....K - I will go dig it up tomorrow....

I think Jeff kind of put it together without quite saying it. In my mind, in order to BE effective, you have to be right. It's a lot...

For what it's worth, assuming pastRate and BackupRate have the same structure, your reworked statement would look something like (with the OUTPUT statement).

;with ratetable (

rownumber,

...

Alen cappelletti (6/13/2008)

---

Hi, I think there is something with replication process.

Yestarday a reset log but now are 4,9 Gb....

Pubblisher create a snapshot at the 5:00 AM ...

I don't understood...

One parting gift....

Wrapping the "CLR Cursor" in a function rather than a SP shaves some minor amount off as well....Still no match for the set-based stuff WITH the helper...

(Jeff - already found it...:). It's not in play in my tests)

update. Like I mentioned earlier, no specific helper index was in place on that last round. ...

The test scheme is here:

[font="Courier New"]DROP TABLE testresult

CREATE TABLE TestResult(

                testID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

                testType VARCHAR(50),

                total money,

                runtime DATETIME)

GO

            DBCC freeproccache

            DBCC dropcleanbuffers

    --===== Common

DECLARE @TimeStart DATETIME

    --===== Cursor

    SET @TimeStart = GETDATE()

DECLARE @SomeMoney    MONEY,

    @SumSomeMoney MONEY

DECLARE...

All right, all right, no need to cry... You wanted all of the tests centralized - you got them. Keeping in mind that there are some very specific...

There are methods to decrypt them. The problem (and I think why you're not getting any answers) is that a forum is a highly inadequate place to ascertain whether...

Again - same link as before. It's a WareZ site, which means that most likely these items are up there pirated/with no authorization.

Someone worked hard on those...

I had the same problem with my initial install of Vista (pre-SP1). For what it's worth - I found that SQL Server would definitely reuse what was there, and...

Oh fair enough Lynn. I just haven't been getting notified about posts, so coming back to find having ballooned out to 60 or so posts was astounding. But...

it's unfortunately got no idea what to do with the float you threw at it. You're likely going to have to cast it back to a varchar, and do...

Wow!~ my own mini religious war! I have to say I'm impressed with how riled up we've managed to get....

Anyway - like Steve has mentioned before - it might...