top of page
Search
The Magic of Ranking, Partition By And Recursive CTE (Common Table Expression)
The Magic of Ranking, Partition By And Recursive CTE (Common Table Expression)
Dec 22, 20233 min read
A Guide to Utilising Monthly Date Tables for Trend Analysis
A Guide to Utilising Monthly Date Tables for Trend Analysis In the realm of data a
Dec 20, 20232 min read
Date Table On The Fly in SQL Server
Create and use Date Table On The Fly in SQL Server
Dec 19, 20232 min read
Mastering Time Slicing: A Symphony of SQL Precision
Our code du jour is a masterpiece that elegantly slices time into manageable intervals.
Dec 18, 20232 min read
Mastering Date and Time Manipulation in SQL Server
This blog post is your guide through practical examples of date and time manipulation in SQL Server, featuring the mighty DATEADD and DATEDI
Dec 16, 20232 min read
Enhancing Time Slicing with Stored Procedure: Part 2
The second part of our two-part series on optimizing SQL Server for efficient time slicing.
Dec 15, 20232 min read
Efficiently Slicing 24 Hours with SQL Server: Part 1
Welcome to the first part of our two-part series on efficiently slicing 24 hours using SQL Server functions. In this series, we’ll...
Dec 14, 20232 min read
IF EXISTS DROP TABLE in SQL Server
As a SQL programmer knowing these different tehcniques goes a long way becasue technical challenges come in many forms and we should be pre
Dec 13, 20232 min read
bottom of page