2021-03-18
650 reads
2021-03-18
650 reads
After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.
2020-05-15 (first published: 2016-10-13)
8,041 reads
This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.
2018-12-25 (first published: 2016-09-19)
7,211 reads
Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.
2017-12-08 (first published: 2016-09-26)
3,910 reads
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
2017-11-24 (first published: 2016-09-08)
17,199 reads
2016-09-05
1,351 reads
2016-08-18
1,505 reads
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
2010-03-16
12,982 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi friends, So I have a Login to a server that is a windows...
We recently had to rebuild servers that were configured with AG. I built everything...
Hi there I have a problem with a dynamicSQL Statement. In this code, I...