Jeff Moden wrote:
There's the occasional gem to be found but...
In my 2.5 months there were 2 answers which stood out as real gems.
Check this out. Ben Thul posted a full working example of hierarchyid complete with .ToString(). Nice!
Also, like many SQL devs I concatenate strings together without a thought all the time. Here's SSC's Thom A (who is Larnu on SO) with a great explanation. A variation of this was posted here on SSC I think.
Two gems found along the dirt road with potholes and errant bullets flying around 🙂
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können