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

Performance

SQL Server Performances – CHAPITRE 2 – Faut-il paramétrer, régler, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]

13 septembre 2024 dans Sites francophones étiqueté cache / CEIP / coeurs / comparaison / compatibilité / CPU / datetime / Instant File Initialization / large pages / Lock page in memory / mémoire / Mémoire compressée / multithread / NUMA / Optimisation / optimiste / parallelisme / Performance / Performances / pessimiste / RAM / requetes ad hoc / sp_configure / SQL Server / SQL Server CEIP / Statistiques / Tuning / verrou / verrouillage par mssqlserver.fr

Friendly Deletes in SQL Server

One of the first things you learn when working with SQL Server, and other transactional based SQL […]

1 mars 2024 dans Sites anglophones étiqueté Blogs / DELETE Statement / Performance / SQL Server par simple-talk.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

Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]

2 octobre 2023 dans Sites anglophones étiqueté Homepage / Normalization / Performance / T-SQL Programming par simple-talk.com

Get the Most Current Row From a Detail Table

Task: Update a table with the most current value of a detail table. In this article I’m using […]

10 juillet 2023 dans Sites anglophones étiqueté FIRST_VALUE / LAST_VALUE / Performance / Performance and Tuning / ROW_NUMBER / t-sql / Update par sqlservercentral.com

SQL Server 2022: Capture SQL Anti-Patterns

One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]

1 juin 2023 dans Sites anglophones étiqueté Homepage / Performance par simple-talk.com

SQL Server Engineering Using Free Tools

You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE […]

28 octobre 2022 dans Sites anglophones étiqueté Free tools / Performance / t-sql par sqlservercentral.com