WorkDay Functions
Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.
2019-09-24 (first published: 2019-09-04)
3,600 reads
Workdays
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
5,191 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
960 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
710 reads
Blogs
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
How to Install DBeaver and Connect to a PostgreSQL Instance
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Forums
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Vector Datatype Dimensions
Comments posted to this topic are about the item Vector Datatype Dimensions
SQL Server DBA - Immediate need
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers