2021-03-18
676 reads
2021-03-18
676 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,198 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)
8,106 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)
4,178 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)
18,210 reads
2016-09-05
1,356 reads
2016-08-18
1,511 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
13,222 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Hi when i think of server hops , i think of how kerberos assists...
Comments posted to this topic are about the item Can/Can't Do/Don't
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers