First, it's not a "n00b" question. There are some complex things that have to be taken into account for this kind of thing.

Now, on to the meat of the...

An "Undelete"...

BobM (3/25/2008)

---

RBarryYoung -

So there is no 'inline' way to update a value before it gets written? Would the update in your trigger cause the same trigger to fire...

It is often helpful to include the error messages you are getting. Or at least a summary of them. For example, if you are getting "divide by 0"...

I don't keep any history tables in the same database. They bulk up backups for no good reason. When I log updates/deletes/inserts, I do so in a separate...

It seems to me that the best way to do this would be separate tables for separate categories of rules.

Really, I'd have to know more about the application to say...

I prefer physical deletion and logging.

Flagging data (virtual deletion) means that every single piece of code, every query, every update, etc., all has to take the flag into account. ...

Chris Gierlack (3/25/2008)

---

Ahhhh wait. Now I'm getting somewhere. Based on what you just said I ran 3 different scenerios:

1) LIKE %nn%

2) LIKE %nn

3) LIKE nn%

1 and 2 took...

I do test restores at least weekly. Usually more often than that.

Good article.

Steve Jones - Editor (3/22/2008)

---

WITH INIT should have no effect on the database. It does remove any backups in that file, but that's separate from your database.

I use WITH INIT...

I tested this over the weekend. Here's what I came up with:

create table Contacts (

ID int identity primary key,

Name varchar(100))

go

insert into dbo.contacts (name)

select top 1000000 clean

from dbo.numbercleanb

go

create table ContactsRelations...

Procs. Definitely.

SSIS can do both of these things.

You can also do them with Open Rowset, if you open that up in the Surface Area Configuration Manager.

Books Online has good data on...

Yep, just tested it and you cannot create an indexed view on Union All.

Testing other solutions now.