L'actualité technique MS SQL Server en France (et ailleurs)

Advanced SQL

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]

12 avril 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Azure SQL / BI / Data / Database / SQL Script / Uncategorized par sqlservercentral.com

SQL Window Functions Series: NTILE()

Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]

3 janvier 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced Querying / Advanced SQL / Data / ntile / Performance / SQL / SQL Script / SQL Server / Window Functions par sqlservercentral.com

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. […]

11 décembre 2023 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 sqlservercentral.com

SQL Window Functions Series: RANK() and DENSE_RANK()

Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]

15 novembre 2023 dans Sites anglophones étiqueté Advanced Querying / Advanced SQL / DENSE_RANK() / Performance / query optimization / RANK() / Ranking Functions / SQL / sql commands / SQL Data Exploring / Sql Functions / SQL Query / SQL Script / Window Functions par sqlservercentral.com

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance […]

21 juillet 2023 dans Sites anglophones étiqueté Advanced SQL / Azure SQL / Azure SQL Database / Microsoft SQL Server (MSSQL) / MSSQL administration / New Feature of SQL Server / Parameter Sensitive Plan Optimization / performance enhancement / PSP optimization / query optimization / SQL DBA / sql server 2022 new feature par sqlservercentral.com

Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]

13 mars 2023 dans Sites anglophones étiqueté #invalidObject / Advanced SQL / Database Administration / Database objects / MSSQL administration / SQL Script par sqlservercentral.com

How to Find the Start and End Dates for the ...
tl:dr See the attached dbo.WeekDates function. You don’t know what you’re missing, though. Prologue Thanks to some really […]

13 juillet 2022 dans Sites anglophones étiqueté @@DATEFIRST / Advanced SQL / business logic / calendar / Calendar Function / Calendar Table / cross apply / date / Date Calculations / Date computation / date conversion / Date Difference / Date Functions / DATEADD / DATEDIFF / DATEPART / Dates / Datetime conversions / Datetime Functions / Jeff Moden / Tips and tricks / WEEK / Weeks par sqlservercentral.com