2025-06-02
504 reads
2025-06-02
504 reads
2024-06-10
483 reads
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
8,240 reads
The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".
2023-08-07
22,484 reads
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
32,650 reads
2020-02-27
23,325 reads
In this piece, learn about changes in UK holidays and get a script to calculate them.
2019-07-15
3,064 reads
2019-07-04
898 reads
2019-04-18
1,467 reads
Function for Getting Interval Dates by days,months,years for particular week number, for particular month, for particular date between 1 to 31. etc...
All in One Date Interval Related Function.
2016-06-27 (first published: 2015-11-27)
1,930 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Hi all, this is my first time posting on this forum, thank you all...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers