Keeping the "don't split things unless there's a good reason to" discussion in mind - if you are implementing a 1-to-1 relationship, then yes - it can be appropriate to...

By the way - another trick if you still can't find this thing:

Dust off a copy of SQL2000's Query analyzer, and use its Object Search ability to find this thing...

From what I can tell - yes.

If I log in to the DB as SA and go to a user DB, then query for an object I know...

What about making a new DB owner/changing the DB owner. Use something like sp_changeDBOwner.

If need be - detach the DB - attach it to a database instance you have...

coming right up!

create table ToUnpivot (myGroupname varchar(20), val1 int, val2 int, val3 int)

insert ToUnpivot

select 'aaa',1,2,3 UNION ALL

select 'bbb',10,12,13 UNION ALL

select 'ccc',21,22,23 UNION ALL

select 'ddd',1,2,3 UNION ALL

select 'eee',11,12,13 UNION...

sounds like those guys shooting turkeys as plane windshields....:hehe:

Ah - the visual... No wonder you were having trouble: you want to UNPIVOT, not PIVOT...:)

Jeff Moden (1/14/2008)

---

Sorry, didn't see that... if you can't find it there, then I don't know where it might be, especially if you're...

There is only if the database is set up to record (in a column) the time the data was entered. It's not an uncommon thing, but I'm assuming you...

Or you can perform a "differential log backup". Meaning - once a day you perform a log backup in its "default" format (which truncates the log for you), and...

Abraham -

I'm not quite sure I get specifically what you're looking to do. You might be able to do this with a PIVOT (or the old-style version of...

Jeff Moden (1/16/2008)

---

Well.... I should have known better... as soon as I saw that it was a Government agency, I should have known that the record layout they provided wasn't...

It's going to tend to drop connection, so it would be a good idea not to do it when users are connecting. It's more like it will drastically slow...

you can double-check if you have the default reports installed. From within SSMS, right-click on the database name, then Report>>Standard Reports>>Disk Usage.

You'll have to do that...

it all depends on whether your data is growing quickly or not. I would check in in a day or two and see how fast it's growing.

If you have...