Thanks for the lock question. I'd like to see more of these.

Thanks for another TDE question Steve. Definitely a weak area for me. I agree with Tom that it is good to have these together. Helps the topic to set in...

Alvin Ramard (7/26/2013)

---

SQLRNNR (7/26/2013)

---

Revenant (7/26/2013)

---

SQLRNNR (7/26/2013)

---

I really do think google would be easier if I could do this:

select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles...

I've never used FTS so I was pleasantly surprised to get this right. Thanks for the question Steve.

Living in the Midwest, I have seen a few new sites pop up. Although I think cloud computing has put a damper on this growth.

Thanks for the question Pramod. I had never considered how output would work with triggers.

Koen Verbeeck (7/19/2013)

---

Rich Weissler (7/19/2013)

---

This question will be fun for the poor soul who attempts to answer the question in 2017 and tries to guess what might have been considered...

MSDN confused me on this one. Oh well, learned something new. Thanks for the question Steve!

Thanks for the easy Friday question.

Fun question. I have never found a good use for these functions either. Your post with all the other examples clearly illustrates how useless it really is. I would like...

I did a search online and I found very few articles discussing temp stored procs. Almost all said that a permanent stored proc is usually better. Most cases for using...

Nice question. I have never used this option. Good to know!

I was looking for the trick in this question and was thankful that there wasn't one. Nice question on a basic function.

I get personal email on my phone and that is bad enough. Between that and texts from friends and work, I have some days where I feel I am being...

Nice discussion even if the original explanation was a bit flawed. Thanks for the question Sergiy.