RE: OT - Datbase Transaction question

[Eric Creese]

well I have a composite primary key but that key index is of no use to me on this. However there are two columns that I will be creating indexes on that will provid the index I will need. The table has 3,199,295 rows

-----Original Message-----
From: Steve Nelson [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 11:25 AM
To: CF-Talk
Subject: Re: OT - Datbase Transaction question

How long does it take to process right now? SQL server shouldn't blink
at 28 update statements. Do you have indexes on the primary keys?

Steve Nelson

Eric Creese wrote:

> I have a stored procedure which runs a series of updates, actually 28
> seperate update statements. If no failures I then do a single commit.
> if error roll back all updates. Kind of an all or nothig deal. Where
> will the biggest performance hit take place?
>
> SQLServer 2000
>
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---