Want...

I believe what you're asking is - should the leading column on a wide non-clustered index have it's own index, so you can seek on that column alone?
It's easy enough...

When selecting 'Unread' posts - does that mean unread by myself or by anybody?
The first time I used it all of the posts listed had 0 views but now that...

Winter tyres. My wife has...

Jeff Moden (1/9/2017)

---

I used to think it odd that people that people I've interviewed with more than 5 years of "experience" with SQL Server that made the claim of being...

DBMS of the year, apparently - http://db-engines.com/en/blog_post/67

I can't go because SQLBits have some software...

Yes, I've been through that pain too. I actually had it working for a while (pretty much using the steps Phil has mentioned) but at one point it all fell...

A year already? When searching for SQL answers I still get hits on his articles. It does make me pause for...