Yeah I am interested in this as I thought for a non unique nonclustered index that the CI key needs to go up the tree in order to efficiently locate...

Jack Corbett (1/7/2016)

---

Ed Wagner (1/7/2016)

---

Thanks for the tip, Sean. I've not yet worked at a company that has an IM - I guess I've been sheltered. ...

Happy New Yr!

I am 5 pounds heavier, finished watching 6 star wars movies and now ready to drink a jug of java juice.

I remember going to a shotgun session up in Scotland and boy the next day I couldn't move! Arms were like jelly.

I have my 12 pack of beer ready, star wars box set and a fridge full of delicious meat, so yeah, I'm doing ok thanks Brandie 😀

Ahhh I wanted to see a light saber! 🙂

I have never heard of conditional. Regarding running vs runnable taken from http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/ :

"A thread is using the CPU (called RUNNING) until it needs to wait for a resource....

Talking and T-shirts + starwars theme I am really liking this one -

https://thwack.solarwinds.com/thread/98313

BrainDonor (11/13/2015)

---

I would just like to say, that I've always admired the people that are willing to publish articles on this site.

Now that I've faced the editor for this, I...

Steve Jones - SSC Editor (11/12/2015)

---

Yeah, what Grant noted. If you're not satisfied in your job, the best time to look and change is when you can do so without...

Grant Fritchey (11/12/2015)

---

BL0B_EATER (11/12/2015)

---

Steve what do you mean by " The best time to get a job is when you have one, so take advantage of that" ... I...

Probably the trace flag route - but this should help (From Bart Duncan)

http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx

I am over-whelmed with all those new features - looks like I will have to book couple days off work to play around with it.

Steve what do you mean by " The best time to get a job is when you have one, so take advantage of that" ... I don't really understand...

GilaMonster (11/10/2015)

---

An uncontrolled shutdown should not have caused errors. It feels like an update to the system tables was lost.

Maybe check with the storage admins that any write caches are...