Jeffrey Williams


Technical Article

Fiscal/Retail 4-5-4 Calendar Function

This function returns a 3 year calendar based on a 4-5-4/5-4-4/4-4-5 calendar, also known as a 52/53 week calendar.  The basis of this calendar function was derived from the NRF retail calendar published at https://nrf.com/resources/4-5-4-calendar and the Wikipedia article published at https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar. The calendar function requires 2 helper functions.  The helper functions were derived from […]

You rated this post out of 5. Change rating

2020-09-21 (first published: )

2,961 reads

Technical Article

Calculating Easter in SQL

Several months ago someone commented on a calendar thread that you should not even try to calculate Easter in SQL Server because the math was too hard.  That got me to thinking and I decided to see if that was actually the case. I found that there are several well known algorithms available - but […]

You rated this post out of 5. Change rating

2020-04-06 (first published: )

5,200 reads

Blogs

T-SQL Tuesday #200: Bad Query signals

By

NO AI was used to generate this content. Grammarly was used to check and...

Project Management – Part 1

By

The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...

Install SQL Server 2025 Container on macOS Using OrbStack

By

My old Dell XPS that I used for personal stuff started to degrade; well,...

Read the latest Blogs

Forums

Reading Parquet using openrowset

By saum70

Hi, We are looking out to read parquet file directly from on premise shared...

Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019

By abdalah.mehdoini

We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...

Forward Deployed Engineers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Forward Deployed Engineers

Visit the forum

Question of the Day

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

See possible answers