Thanks for the update. I was just about to say re-enter, but it's good to see a default helped here.

IIRC, you should be able to specify an account for the IIS site (or app pool even), that proxie's all the users requests. In essence, from a Windows AD point...

Should be no real performance impact. It's a minor security check across databases, but it should be overwhelmed by the time for the job.

I'd defer to Gail here, and I agree. Merge the indexes. AFAIK, the order of columns in the include doesn't matter.

+1 for what Grant says, and be sure you watch space with the new indexes as well. More indexes will be more space, and more insert/update/delete impact.

That's why I always keep placeholders around: https://voiceofthedba.wordpress.com/2014/11/24/placeholders-for-emergencies/

GoofyGuy (6/30/2015)

---

One question I often ask is, 'What are the title and author of...

Both. I certainly get caught up with work at times.

gregs 79056 (6/30/2015)

---

This has to be the best post I have ever read from you Steve (and I read most of them).

I often forget why am working and do what...

craig 81366 (6/30/2015)

---

I agree with the general sentiment, but there's one sentence that bothers me.

Perhaps I've misunderstood, so I quote the sentence slightly reworded to reflect my understanding of what...

The best way to fix this is to restart SQL Server in single user mode (-g) and then log in with the DAC locally as a windows admin. You'll have...

Ditto.

Congrats

Jack Corbett (6/29/2015)

---

My instinct is to change the clustered index to be unique and drop the non-clustered because I can't think of an instance where the optimizer would...

They catch mice then.

We got a new little one at the ranch.