Nice question.

To me it seems rather obvious that if you disable the clustered index then no other index on the table will work because all the other indexes identify rows...

Jeff Moden (6/5/2015)

---

You don't have to win to plant a seed. Even a cement parking lot, like your Dev Guy, has a crack in it. 😉

Great article, though....

Certainly that dev guy had it hoplessly wrong, but you too have it wrong - not hopelessly wrong, but somewhat wrong.

During much of my career I've had...

You are being too complicated, this is actually quite simple.

This works for the data you have posted:

--create test data

set dateformat dmy ;

create table #tim (start datetime2, end1 datetime2);

insert #tim values...

Alan.B (6/3/2015)

---

TomThomson (6/3/2015)

---

Luis Cazares (6/3/2015)

---

Eirikur Eiriksson (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Lynn Pettis (6/2/2015)

---

SMH...

Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of...

Robert Eder (6/4/2015)

---

Sean Lange (6/4/2015)

---

Robert Eder (6/4/2015)

---

The problem with script A is the constraint name will be system generated. Script B is also written to use a system generated...

Braindead comment removed. Must remember to switch brain on before applying fingers to keyboard.

SQL-DBA-01 (6/5/2015)

---

Filtered indexes are defined on one table and only support simple comparison operators. If you need a filter expression that references multiple tables or has complex logic, you should...

I dislike script B intensely (too verbose and splitting one operation into two without wrapping a transaction around them). Pity it's what I've become used to getting (in fact...

Luis Cazares (6/3/2015)

---

Eirikur Eiriksson (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Lynn Pettis (6/2/2015)

---

SMH...

Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when...

It might be nice if an expert on indexes could look at this one. I've made a stab at it, but I'm not confident that I've got it...

Thanks for teh extra informtion. Having seen that I think I would go for using UploadID as UNCLUSTERED primary key and have a CLUSTERED index with key (PeriodNo, UploadType)....

I could make a wild guess but my best answer, since you haven't provided enough information to do more than just guess, is "it depends".

Some of the questions that need...

Nice straightforward question. Don't know why it should be two points, though. 🙂

Of course the second reference in the explanation is a lovely illustration of the sheer awfulness of...

Nice, straightforward question.

Perhaps rather easy, as it would be appallingly bad language (type system) design if either of the other options were correct instead of this one.