Calculating Concurrent Sessions, Part 3Commented on: 1 year ago
(February 10, 2013)
I realize that I'm incredibly late in responding but, oh my! How very clever! I was trying to do something similar and got hooked because I just didn't see the 2:1 ratio in the final...
Row-Concatenation Solutions Aren't All EqualCommented on: 2 years ago
(January 2, 2012)
Before all of you give up on the "self referencing" variable, please see the following post over on SSC...
Build the Numbers Table You NeedCommented on: 5 years ago
(March 1, 2009)
Although I applaud the author for a well written article, there are many ways to effectively generate a list numbers... and recursion isn't one of them.
SQL Server Management Studio is a complex application that does a ton of wonderful things and, with SSMS 2014, there are still a couple of quirks or issues that I hope that Microsoft addresses or corrects someday....More
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More