I think the term you are looking for is EffectiveDate. In the case of your example this should also include the time as well, so perhaps EffectiveDateTime would be...

I did get to hear him do this one. And, yes, I could still hear him doing it as I read it also.

Here is a quick question before i try answering your question. Is the most recent record in the HOUSE_HISTORY table considered current where as the other records are historical...

Kit G (2/3/2009)

---

Not sure if this is the one you're...

You know, Carryball just doesn't have the same "kick" as Football. Of course we have to add the American to it so that the rest of world knows we...

How many rows in the table?

Anybody have Goerge Carlin's description of football handy? I think that pretty much tells it all quite well.

NotManyPoints (2/3/2009)

---

Lynn, yes possibly I was a little harsh, but if it does not kill us it makes us stronger blah, blah…..

To know it was not a concern you must...

Sql Student (2/3/2009)

---

Thanks,

But there are no topics for incremental backup in Books online. I need to learn how to setup incremental bakps that runs every 4 hours and how can...

santhosh (2/3/2009)

---

If our database is in simple recovery mode. Is there any chance to overwrite the uncommitted data by any other user?

If this happened how to rollback the data from...

Should have seen this from the initial post, this is PeopleSoft. How was/is this query generated and supported? Is it built and maintained using the PeopleSoft tools? ...

NotManyPoints (2/3/2009)

---

This is why so called DBA's can exist because standards can be low. They then end up in a...

Double post. Please see this thread.

Best place to start is BOL (Books Online). It can provide you much of the information you are looking for regarding backups.

LeeBear35 (2/3/2009)

---

Lynn Pettis (2/3/2009)

---

LeeBear35 (2/3/2009)

---

Not that I want to complain, but does anyone see a problem with a company that would retain a person that consistenly produces code like this:

DECLARE...