2020-03-30
477 reads
T-SQL
2020-03-24
480 reads
Combining many crossing intervals
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
2020-03-16
1,992 reads
2020-03-10
810 reads
Gap Analysis Using Algebra
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
3,987 reads
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
4,418 reads
Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
7,469 reads
2020-03-02
767 reads
Mean Median Mode using SQL and DAX
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
2,114 reads
2020-02-27
10,978 reads
Blogs
Disks performance in Azure
By nelsonaloor
In our earliest post, we have discussed in detail about the factors that affect...
Covid Thoughts, So Far
By Andy Warren
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...
How to Think Like a Certification Exam at the PASS Professional Development Virtual Group
By Will Assaf
Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...
Forums
Query help for special condition
Hi sql gurus, I am currently doing some R&D on MERGE statement and as...
Going Back to the Basics
In the past couple months, I have helped people understand a handful of topics...
Advantages and Disadvantage using Temp Table or Fisical Table
Please share your thought about advantages and disadvantages for processing using temp table or...
Ask SSC