You almost had me on this one until I remembered what day it was. Good one though!

Well I got it half right! I thought about picking just the CHECKDB without the REPAIR_REBUILD but thought it wouldn't hurt to run it with the extra option. Regardless this...

Nice question, thanks Andy!

+++1 yep. I always forget...

Very glad that this syntax is finally gone. I had to convert a bunch of queries from using this syntax a few years ago and I still cringe when I...

Interesting question Hugo. I don't think I have seen any others related to this before on here. Thanks for the info!

Thanks for the question on this new 2016 feature.

Great question Hugo and a very nice explanation. I look forward to the third edition of Grant's book as well as that eventual Pluralsight course!

I guess this is what I get for going back and answering an old QoTD. 😛 Not sure if I can still get points back for this question or not?...

Nice question, very informative. I got confused and was thinking hash join and not hash match. Oh well. 🙂

Very informative as usual Hugo! Odd that I couldn't find anything online regarding this. Thanks for the explanation!

g.britton (10/23/2015)

---

Poorly worded. The expression does not "converts to NULL and removes beginning and trailing spaces", which implies that it first converts to NULL then removes the spaces...

Nice question Steve. I don't use tally tables much but they sure are a nice option to have.

Argh!! Wasn't paying attention apparently and selected the id number and not the number of rows returned. 😛 I think I need to leave early today.

TomThomson (10/15/2015)

And if the column in SalesOrderHeader called salesorderid identifies a product rather than an order the person who devised the schema should be forbidden ever to name any column...