Comments Feed

The Logical Puzzle - 28 Mar 2008 Commented on: 9 weeks ago (August 18, 2017)

Hi doctor_j,

You're missing the tool element. You're right that one builder would build six houses in nine years, but that's with one and a half tools. With one tool, one builder will build...

Logical Query Processing Part 7: GROUP BY and HAVING Commented on: 9 weeks ago (August 18, 2017)

Hi Ederik,

The denominator needs to be a window aggregate function because it needs to operate on the entire query result (grand total), which is different than the grouping set's...

T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition Commented on: 14 weeks ago (July 11, 2017)

Well said, Kenny!


What You Need to Know about Distinct Windowed Aggregate Calculations Commented on: 19 weeks ago (June 8, 2017)


What You Need to Know about Adaptive Joins over Rowstore Commented on: 21 weeks ago (May 26, 2017)


New Solution to the Packing Intervals Problem Commented on: 22 weeks ago (May 16, 2017)

Hi Samuel,

Glad you found the class helpful, thanks!

As for your question, based on the data you provided, the results seem right. Running the complete solution:


OFFSET/FETCH, Part 1 Commented on: 23 weeks ago (May 10, 2017)

Thanks sateeshmach; I appreciate the feedback!

Ordered Set Functions: What's New--and Missing--in SQL Server vNext Commented on: 26 weeks ago (April 18, 2017)

Hi sateeshmach,

This is not for me to say but for Microsoft. As a general rule, it's not common for Microsoft to add new features in a service pack update, although this does occasionally...

How to Compute Date and Time Difference in Parts Commented on: 31 weeks ago (March 17, 2017)

Hi McSick,

My solution relies on DATEADD and DATEDIFF, both of which handle leap years correctly. For this reason, there's no need for explicit handling of leap years. For instance, the...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Jul 17, 2017

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×