Err.. without any clue of what you mean by 'crashing', it's a little hard to have any useful advice. Could you perhaps be a little more specific?

Yes. Heavy CPU and IO load.

We have a 3TB database and we are planning to...

Yup, that's about it for SQL 2000's error handling. Fun, isn't it?

Dave Hall (1/25/2013)

---

I'm calling the 1st Proc like before and the transaction errors are gone (yay) BUT the Delete statement still executes and is not rolled back (boo).

I thought that...

Dave Hall (1/25/2013)

---

Thanks, GilaMonster. I have indeed learned that they are a pain!

I understand the concept of how nested transactions work and have tried using @@Trancount to see if...

Nested transactions are a lie (and a major pain)

The rollback in the inner procedure rolls back all the way to the first begin tran

Hence you enter the inner proc with...

Add a datetime column that defaults to getdate(), that's the date inserted. You can then max that and group by account to get the latest rows

SQLRNNR (1/24/2013)

---

ChrisM@home (1/24/2013)

---

SQLRNNR (1/24/2013)

---

ChrisM@home (1/24/2013)

---

SQLRNNR (1/24/2013)

---

john.arnott (1/24/2013)

---

Am waiting with bated breath to see if "Saint" Lynn lives up to his kind and understanding reputation. Someone stumbled on an...

poratips (1/24/2013)

---

Now i have to DateTime Column - OpenDate and closeDate, I need to use following logic:

If Opendate > Today's date then i need to move into Partition1

If Opendate =...

You can partition an existing table.

Cool, then start by doing a lot of reading on partitioning, it's not something you want to implement without a good understanding.

You have inadequate space on the TempDB drive and the user database drive to rebuild a clustered index (yes, rebuilding requires the same free space as creating it), that's a...

CREATE PROCEDURE search_orders @custid nchar(5) = NULL,

...

That looks pretty full to me.

I think, before worrying about indexes, you might...

Partitioning is not primarily for performance. It can improve performance, but that usually requires queries constructed to take advantage of the partitioning. If your...