SQLRNNR (3/5/2015)
dwain.c (3/5/2015)
Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not play well with IE11?I would say it doesn't play well with IE11. Lot's of things don't play well with IE11. Have you tried compat mode? Or another browser?
I tried compatibility mode but I don't have any other browsers installed on this laptop. And assuming this is an IE11 not playing well thingy, the compatibility modes aren't as compatible as you would want them to be (they didn't work back to IE7).
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St