SQL Server
How minimal is SQL Server Minimal Logging
One day, one of my clients complained about the size of his SQL Server log. He mentioned that it had reached 1GB for just 1 million inserted rows. His issue was that sometimes he had to insert 1 billion of them ! Hopefully there is SQL Server…
SQL Server Cumulative Updates Dashboard
SQL ServerSince the version 2017 Microsoft does not use Service Packs anymore : only Cumulative Updates. Thanks to Microsoft SQL Server Team, they provide Excel summary and details about fixes included in each cumulative updates. Theses data allow…
Semantic Vector Search with SQL Server and the help of KMeans indexing
In the previous article Semantic Vector Search with SQL Server we discuss about the possibility to make semantic search with vectors that comes from OpenAI text embedding model « text-embedding-ada-002 ». We also have seen how the dimensional…
SQL Server vector search
Some time ago i read a blog article from a senior Microsoft azure programmer Davide Mauri : The article interest me because the current « semantic search » natively available in sql server since SQL Server 2016 is not wildly spread and honestly…
TPCH SF10 : Query 13 and SQL Server Collations Performance Impact
After benchmarking several cloud databases (Snowflake, BigQuery, SingleStore, Databricks) using TPCH SF10 data, after benchmarking DuckDB and Tableau Hyper on my own machine, I ask to myselft : « hey, why not testing using the official SMP Databases…
SQL Server Extended Events Dashboard
SQL Server Extended Events is a powerful feature in Microsoft SQL Server that enables database administrators to capture and analyze events that occur within the server. Extended Events provides a lightweight and customizable infrastructure that can…
SQL Server Features Comparison and Evolution
Let’s concentrate on the last 3 versions to see features evolution and comparison between edition. Clic, Ctrl+Clic, or mouse maintain and select area to filter others on th dashboard. Click elsewhere to release filter or change it. On the…
Database Engines Trends Dashboard
Database Engines Trends DashboardDB-Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server, PostGreSQL, MongoDB, Redis to omes more confidential like Hazelcast…
SQL Server editions comparison dashboard by domains features and scale capacities
The article allow you to direct use the sql server editions comparison dashboard You can select the version of SQL Server You can select a group of features to adapt the details with your selection Multi-selections is also…
Insert data from SQL Server into Excel crosstab
Insert data from SQL Server into Excel crosstabIn this article, I will show you how to insert data into an Excel spreadsheet and safely keep your content. Indeed, if you try to insert data into Excel, which contains a crosstab, you will corrupt your…
SQL Server Standard vs Enterprise Edition Features History
SQL ServerAlong the time Microsoft improve performance and add features to the SQL Server Database. The two principals editions are Enterprise and Standard edition (EE and SE) but there are also others versions like the web edition or the free one :…
SQL Server Trace Flags Classification
SQL Server Trace flags are used to set specific server characteristics or to alter a particular behavior. For example, trace flag 3226 is a commonly used startup trace flag which suppresses successful backup messages in the error log. Trace flags…
Compression des données XML dans SQL Server
SQL ServerAlexandre Blois Problème : On stocke des données XML dans une table qui commence à grossir sérieusement et il devient important de réfléchir à des solutions pour essayer de gagner un peu de place de stockage pour éviter que la table…
150 T-SQL Bad Practices
Many times i was asking for given best practices for T-SQL code but I don’t like best practices advices. They can be deprecated faster than you think and they can be a good advice in one case and very bad advise for another case. T-SQL Bad…
SQL Server CLR Functions vs SQL 2019 Function Inlining
Booster vos performances SQL Server en utilisant des fonctions compilées CLR C# à l'intérieur même de votre SGBDR préféré à la place des fonctions SQL classiques ! Ce tutorial montre toutes les étapes pour : écrire une…