Challenges will mainly depend on the amount of data and what you can allow for downtime, or if you can do an online rebuild.

GSquared (10/3/2012)

---

The solution Joe provides doesn't actually prevent gaps. The PreviousEndDate column...

The solution Joe provides doesn't actually prevent gaps. The PreviousEndDate column joins...

One reason to keep servers running is that turning a computer on takes about as much energy as running it for 1-3 hours, because capacitors have to be charged up,...

patrickmcginnis59 (10/2/2012)

---

...

So, I post a list. A manager reads it, memorizes it in the hopes it will help deliver the interview. A person masquerading as a...

GUID vs BigInt vs Int for a surrogate primary key, or the leading edge of any index, is all about what you want the index/key to do. There is...

Yes. The reason to not add indexes you don't need isn't because of performance degredation. It's because you'll be wasting drive space on storage, and CPU cycles on...

patrickmcginnis59 (10/2/2012)

---

Grant Fritchey (10/2/2012)

---

patrickmcginnis59 (10/2/2012)

---

Grant Fritchey (9/21/2012)

---

Lowell (9/21/2012)

---

ok, I have my own my knee jerk reactions for the things to review.

Grant wanted to avoid putting the answers on the forum,...

Sure, you can add that index. I'm not sure why that view would exist, since simply selecting from b would be easier and would do the same thing.

Ellen-477471 (10/2/2012)

---

Is there a chart somewhere that shows the maximum number of identity values for the data type used when creating an identity field in a table?

I've searched for this...

dan-572483 (10/1/2012)

---

You have an ORDER BY clause with a field from the joined table. Since ORDER BY can't evaluate null, I think this is making it an inner join.

I'd...

CptCrusty1 (10/1/2012)

---

GS, the questions KIND OF relate in that the whole reason I'm trying to interview a DBA is because this vendor stinks. The questions are a direct indicator...

Do you have a Users table? If so, you need to start from that, then join to UsersCurriculum and then Curriculum.

Otherwise, you don't have a full list of users.

If...

CptCrusty1 (10/1/2012)

---

OK... so here's a question for you serious DBA's.

My DBA Vendor indicated that they had to delete indexes before creating primary key's on a table. They created the...

The query is backwards for that. The left join you defined would find a curriculum that has never had any users, not the other way around.