Date Calculations

Creating a Date Dimension (Calendar Table) in SQL Server

Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]

 dans Sites anglophones  étiqueté Analytics / business intelligence / data analysis / Date Calculations / date dimension / Date Formatting / Date Functions / Date Metadata / Date Range / Fiscal Year / Recursive CTE / Reporting / SQL programming / SQL Queries / SQL Server / SQL Server 2022 / SQL Server Development / SQL Tips / t-sql / time intelligence / Time Series Analysis par

SQL Window Functions Series: LAG() and LEAD()

In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]

 dans Sites anglophones  étiqueté #sql interview questions / Advanced SQL / Data / Database / Date Calculations / Date computation / DATEDIFF / LAG / LAG function / LEAD / OVER() / Performance / Performance and Tuning / Performance Tuning / Programming Language / SQL / SQL Compare / sql monitor / SQL Performance / SQL Prompt / SQL Script / SQL Server / t-sql / time series / TSQL / Window Functions par