Jeff Moden (7/3/2008)

---

Jeff Moden (7/3/2008)

---

Nah... I'd get it wrong... I...

The purpose of doing looped Deletes is usually two fold...

1. Do the deletes and still allow the table to be used.

2. Keep the transaction log small.

Item #2 above...

I can see using table variables in test environments to test insert/update/delete processes in a explicit transaction. In SQL Server 2005 this is easier using the OUTPUT clause to...

Ron Kunce (7/3/2008)

---

jim.powers (7/3/2008)

---

This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

In the Workgroup column on the row for RAM, the limit...

Steve Hindle (7/3/2008)

---

Thanks you for all your replies.

I have also been experimenting...

I created:

Full1.Bak

Tran1.TRN

Full2.BAK

Tran2.TRN

using SQL2005. I deleted Full2.BAK and restored Full1.Bak, Tran1.TRN and then Tran2.TRN and this worked.

I'm still a tad...

And another hearty Congratulations!

😎

Contratulations to both of you!

😎

I'll ask a more general question first. What is being deleted, and what are the requirements for the solution you are working on? I ask, as another way...

Andrew Hall (7/1/2008)

---

Previous script returning a string for days when age < 1 month wks 1-3 months and months < 1 year has an out by one error on the...

Sergio Lugo (6/30/2008)

---

Hi everyone !

I use this formula:

Age = floor(datediff(day, [DateOfBirth], getdate())/(365.25))

You can also put it in a calculated column.

It works (I think) because one year actually has 365.25 days......

After seeing this error in another forum thread, I have 2 possibilities. One, the recovery model being used has changed on the database. Two, a BACKUP LOG WITH...

Does this help you with getting you where you need to go?

create table #ActiveStatus (

AcctId int,

ActiveStatus bit not null, -- 1 =...

Is this regardless if it also went inactive during that same time (ie does it matter the order of active/inactive)?

😎

Have you run a dbcc CheckDB on the database? Read BOL first, as you only want to see if there are any errors, you don't necessarily want to fix...

To make sure anyone who helps you is on the same page a little more info is required. If you could provide the DDL (create statement for the table(s)),...