Hi Jeff! Here's a version that I've used for a while that's been pretty handy for me:

CREATE FUNCTION dbo.fnTally(@RowCnt bigint, @ZeroOrOne bit = 1)
RETURNS TABLE WITH SCHEMABINDING
AS...

I have used the analogy of medical doctors before to describe the different fields within the computing space. It does help people to recognize that there is quite a bit...

• This reply was modified 5 years, 6 months ago by  Aaron N. Cutshall.

I thought the same thing initially, but it won't work because DATEPART(mm,oh.OrderDate) is not part of the GROUP BY whereas DATENAME(mm,oh.OrderDate) is.

Arg! I clicked the wrong one! I got so excited because I new that it would list it by month name yet be in the proper order (month number). This...

Great article Thom! I've been working on a SQL Saturday presentation right along these lines. There were a couple of points that I'd like to include in my presentation with...

This post was a great recognition to those who travel extensively and the impact that it has on them and their family. For a period of time, I figured that...

Good morning Steve! When travel becomes a weekly issue with multiple legs on the journey, such scheduling issues can indeed become a major problem. I figured out one time that...

I tend to agree with Jeff in that the length of the presentation depends on the subject and the required depth of discussion needed for it to be properly understood....

I agree that NoSQL environments have their niches and work well within those, I believe that too many problems arise when folks try to use NoSQL environments for problems that...

What really gets me is that so many of the NoSQL databases now offer an SQL interface. I have seen folks go to great lengths to avoid using a relational...