In MS SQL, January 1 of any year defines the starting number for the week. The DATEPART(wk, 'Jan 1, xxxx') always return 1. However, a lot of reports Week No is actually based on ISO 8601 standard, that is January 1 of any year can be Week 53/52 or Week 1. (http://www.merlyn.demon.co.uk/weekinfo.htm#IDC)The Rule is as […]
2005-06-14 (first published: 2005-05-27)
297 reads
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Powershell script to generate SQL...
Comments posted to this topic are about the item Database Ledger in SQL Server...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers