waxb18 (11/20/2013)

---

Update:

I have taken the Type, ID and Date of each of the tables, union'd them and sorted them to give me a chronological view.

The next stage im thinking would...

Just taking a quick look I don't see anything showing what the output should look like based on the sample data in the tables. Can you please put together...

With 98 million rows of data something tells me there is more to this than you are telling us, just a gut feeling.

Is there anything else we should know about...

Not enough to really provide much help. First thought would be to use a recursive CTE to get the data.

If you would like more help, please read the first...

Full and differential backups do not break the log chain of tlog backups.

As long as you don't do anything to break the tlog chain, when you restore your full and...

Start with a solid backup plan that you test regularly. Sounds like your database should be using the full recovery model and that your backup plan should use a...

Not much more we can do with as little information as you have provided. Please read the second article I reference below in my signature block. It will...

First, Tom, you are right about that code. I looked, I saw, I ran away! The mixing of Left, Right, and inner joins and then nesting them to...

Peter Schulz-485500 (11/17/2013)

---

Well, I guess you're right, and I agree. I inherited the code and yes, it won't stay this way.

But my question is rather why does something like this...

You could try the following, but remember it is completely untested as there was no DDL (CREATE TABLE statement) for the table, or sample data (in the form of INSERT...

WayneS (11/16/2013)

---

Lynn Pettis (11/13/2013)

---

Just finished the interview, and I feel like a Junior...

RBarryYoung (11/15/2013)

---

Lynn Pettis (11/13/2013)

---

... I will also look in Denver, but I won't commute. If I get a job up there I'll get a small apartment and come...

Sean Lange (11/14/2013)

---

IgorMi (11/14/2013)

---

You question is not very clear, but guess what you're asking...

By specifying identity(1,1) primary key, you already have clustered primary key. For the property identity(1,1) there...

Jeff Moden (11/13/2013)

---

Sean Lange (11/13/2013)

---

Grant Fritchey (11/13/2013)

---

Lynn Pettis (11/13/2013)

---

Just finished the interview, and...

Just finished the interview, and I feel like a Junior DBA. I...