garethmann101 (11/20/2008)

---

One more thing on the full-text index. Is that fully contained within the database? I noticed when I created it that I first had to create a catalog. When...

Lee Nadelman (12/11/2008)

---

You have to presume some things in this question. For example, the question didn't state that the INSERTs were committed. The question doesn't even state...

Peter Schott (12/11/2008)

---

Gotta agree with the majority on this one - the existence of a full database backup was implied and the success of the log backup was implied. ...

You're still short 2 points as it was a 3 point question!

michael vessey (12/11/2008)

---

Some people are suggesting that we are assuming that the log backup is successfull but that this is not explicitly stated.....

ok - to take that point further -...

Grant Fritchey (12/10/2008)

---

Pull a previous copy out of source control...

If you don't have your code under source control, here's the wake-up call to get it there.

You can't retrieve a previous...

I agree with all of the other posters that the question is very misleading. To have a successful log backup one must have the initial full backup.

I suspect that...

This has been extensively discussed on the forum along with some suggestions, including use of a proper source control system.

See my message (474053) as to how we do it in...

I'm with Grant.

I.e., we are a SaaS environment with a separate database for each customer all running the same code.

We store all of our code (one file per object) in...

I'll qualify my responses as follows:

If you are designing and building a system that will be used within a single language culture then by all means choose the proper database...

True, but the support of extended (8-bit) ASCII is also governed by the collation of the database and the calling application, among...

Note that even in America, extended ASCII is very common. Just think of all of peoples names that have accents in them. Or the word resumé. Let...

Having 10+ years of Oracle experience, I understand your problem.

SQL Server doesn't offer the same hierarchical functionality as Oracle's "CONNECT BY" clause.

The solutions are:

1. Use a recursive Common Table Expression...

The Title is completely misleading. "Date of Easter" formulas have been around for decades. It was one of my early computer science homework assignments.

Additionally,

1. It doesn't properly support a legitimate value of -1 as -1 is being used to indicate that the value is not numeric.

2. An explicit CAST is needed in the...