Welcome back!
This time an introduction is needed expecially for my friends who live in different countries than Italy. Here in Italy Corona Virus is hitting hard but we certainly won't stop!
A thought to those who have lost a loved one or their job.
Introduction
I must admit that is strange to write a post in the days of the coronavirus.Today for me and for some other collegues is the first day of smartworking.
All right, I must say, but the change in habits is felt.
Last night I had already prepared everything I needed but today a little anxiety about possible technical problems was definitely in the air!
So there is no time left for any post and for this reason I decided to publish the index of all the posts written during these months.
83 posts have already been published. All posts are written both with the desire to communicate a passion and to convey concepts and practical things that can be useful to most.
First posts were written in italian language then i switched to english.
The index
- Year 2019
- July
- Scrivere Query performanti ...la tua Query è SARGABLE?
- Il TEMPDB e la sua configurazione.. pronti per le Ferie?
- SQL Server & come spostare il database TEMPDB
- Cos’è il database TEMPDB? ...e quindi perché è importante.
- Tremate tremate gli hacker sono arrivati ...ovvero la SQL INJECTION
- Hei! chi è stato a cancellare le righe dalla mia tabella?
- Hei! chi mi ha cancellato la tabella?
- August
- Di database corrotti ed aziende bloccate
- SET IDENTITY_INSERT, a cosa serve?
- Trigger e la funzione UPDATE()
- Di sottoquery ed ottimizzazioni (parte 2)
- Di sottoquery ed ottimizzazioni (parte 1)
- Le Common Table Expression (CTE) che cosa sono?
- Identificare la versione di SQL server? Semplice!
- September
- SQL Server 2019 ed il Memory-Optimized TempDB Metadata
- SQL Server 2019 e l'hint QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n
- SQL Server 2019 RC1 e la "Resumable Online Index Creation"
- SQL Server 2019 RC1 a proposito di "Online clustered columnstore index build and rebuild" (parte 2)
- Confronto tra "Temp Tables" (#) e "Table Variables" (@)
- Le Table Variables // Le novità introdotte con SQL Server 2019. (Parte 2)
- Le Table Variables // Tutta la loro storia, come ottenere maggiori prestazioni attraverso il trace flag 2543. (Parte 1)
- La clausola NOLOCK. Approfondiamo e facciamo chiarezza!
- Installare ed utilizzare le RML Utilities per SQL Server. Come generare un carico di lavoro!
- October
- SQL Server: Transazioni, Lock e Deadlock. Un po di teoria spiegata in modo semplice!
- SQL Server 2019 e la funzione Approx_Count_Distinct
- SQL Server 2019 ed il Batch Mode on Rowstore
- SQL Server 2019 e le inline scalar function
- SQL Server, il database recovery e le fasi di Analysis, Redo e Undo
- SQL Server Ottimizzazioni: non omettere il nome dello schema! (schema name resolution)
- SQL Server & Cambiare le impostazioni relative alla lingua
- SQL Server e gli Extended Event
- T-SQL & quando gli update non aggiornano nessuna riga
- November
- NEWS! Edizione Speciale! SQL Server 2019 è arrivato tra di noi!
- SQL Server Performance Blog by Luca Biondi
- SQL Server ottimizzazioni: perchè non utilizzare l’asterisco nelle SELECT?
- Sargable Queries part 2. Examples
- Write high performing query: Is your query SARGABLE?
- SQL Server 2019 and the Accelerated Database Recovery
- SQL Server, the Parametrization and the Parameter Sniffing
- SQL Server, come vedere tutte le proprietà di una tabella con un solo comando
- SQL Server, The Logical Query Processing Phases. In quale ordine viene processata una Query?
- December
- Draw with SQL Server, plot the Mandelbrot set!
- SQL Server, A problematic Query with a Nested Loop and a huge list of ID
- SQL Server, Il vostro "super cliente" è bloccato! (MSQL_DQ e PREEMPTIVE_COM_QUERYINTERFACE Wait states)
- SQL Server, Math and Applications
- SQL Server, DECIMAL and FLOAT data types. Are you ready to deep dive into the secrets of SQL Server?
- SQL Server trigger optimization part 1
- SQL Server and the JOIN operators part 1
- Year 2020
- January
- Inside the SQL Server Query Optimizer - part 1 Introduction and the input tree
- Inside the SQL Server Query Optimizer - part 2 All about the Simplification
- Inside the SQL Server Query Optimizer - part 3 Cardinality estimation
- SQL Server, How to find deadlocks: the easy way DBCC TRACEON (1204, 1222,-1)
- SQL Server, Why doesn't my update come to an end? a light post!
- Your biggest customer can’t work! It is stuck due to a SQL Server randomly crash? And now?
- SQL Server, Again info about statistics and the "Ascending Key Problem"
- February
- Inside the SQL Server Query Optimizer - part 5 The cost based optimization process and the Rules
- Error Message 468: Cannot resolve the collation conflict between “AAAA” and "BBBB" in the equal to operation. The Collate Error
- Inside the SQL Server Query Optimizer - part 4 Trivial Plan
- Is your SQL Server running SLOW? Then you could have an "High Count VLF" problem! TIPS for the DBAs
- SQL Server Optimizer and The partial aggregate, GenLGAgg e LocalAggBelowJoin rules
- SQL Server, Sub-Queries vs. Cross Apply
- SQL Server and the Plan Guides, An easy way create and utilize!
That's all for today.
See you soon,
Luca
Luca Biondi @ SQLServerPerformance blog 2020!
Previous post: SQL Server, the ANSI_WARNINGS option