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

SQL Performance

Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – […]

15 juin 2022 dans Sites anglophones étiqueté SQL DMV / SQL in Sixty Seconds / SQL IO / SQL Performance / SQL Server Files / SQL Video par journey to sqlauthority

SQL SERVER – Script to List Database File Latency
Today, we will see a very interesting script to list database file latency. I use this script […]

7 juin 2022 dans Sites anglophones étiqueté Disk / SQL DMV / SQL IO / SQL Performance / SQL Scripts / SQL Server par journey to sqlauthority

Indexing for Delete – SQL in Sixty Seconds #197

In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your […]

13 mai 2022 dans Sites anglophones étiqueté SQL Index / SQL Performance / SQL Server / SQL Video par journey to sqlauthority

When was Stored Procedure Last Compiled? – Interview Question of ...
Question: When was Stored Procedure Last Compiled? Answer: Honestly, it is difficult to figure out when was […]

6 septembre 2020 dans Sites anglophones étiqueté SQL Cache / SQL Interview Questions and Answers / SQL Performance / SQL Scripts / SQL Server / SQL Stored Procedure par journey to sqlauthority

Full-Screen Execution Plan – SQL in Sixty Seconds #117
I spend my most of time in a day helping client improve their SQL Server Performance at […]

4 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL Performance / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Execution Plan – Estimated vs Actual – SQL in Sixty ...
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution […]

31 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Performance / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Single Column Single Row and TABLE SCAN – SQL in ...
Can a single column and single row result do an entire table scan? I recently got this […]

27 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Operator / SQL Performance / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Dirty Read with NOLOCK – SQL in Sixty Seconds #110
My primary job is that help various organizations to tune their SQL Server performance Comprehensive Database Performance […]

26 août 2020 dans Sites anglophones étiqueté SQL Performance / SQL Scripts / SQL Server / SQL Video / Transaction Isolation par journey to sqlauthority

Move TempDB for Performance – SQL in Sixty Seconds #107
Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that […]

22 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Performance / SQL Server / SQL TempDB / SQL Video par journey to sqlauthority

Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
Query tuning and optimization is my favourite thing when I am working on a Comprehensive Database Performance […]

21 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL Operator / SQL Performance / SQL Scripts / SQL Server / SQL Table Operation / SQL Video par journey to sqlauthority

Rollback TRUNCATE – Script – SQL in Sixty Seconds #105
One of the most popular questions, I keep on receiving is that – Is it possible to […]

20 août 2020 dans Sites anglophones étiqueté SQL Performance / SQL Scripts / SQL Server / SQL Video / SSMS par journey to sqlauthority

SQL SERVER – Live Query Statistics – SQL in Sixty ...
It is very easy to know what is the queries past and future with the help of […]

19 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Performance / SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Do MAX Function Scan Table? – Interview Question of the ...
Question: Do MAX Function Scan Table to retrieve the data? Answer: Yes, if there are no indexes […]

16 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL Interview Questions and Answers / SQL Performance / SQL Scripts / SQL Server par journey to sqlauthority

Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive […]

14 août 2020 dans Sites anglophones étiqueté SQL Identity / SQL in Sixty Seconds / SQL Performance / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Keyword Join or Inner Join – SQL in Sixty Seconds ...
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same […]

11 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Joins / SQL Performance / SQL Server / SQL Video par journey to sqlauthority

Where are Table Variables Stored? – SQL in Sixty Seconds ...
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted few […]

6 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Memory / SQL Performance / SQL Scripts / SQL Server / SQL Variable / SQL Video / Temp table par journey to sqlauthority

SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE
Recently I found an interesting situation with one of my clients when working on Comprehensive Database Performance […]

4 août 2020 dans Sites anglophones étiqueté SQL DMV / SQL Index / SQL Performance / SQL Scripts / SQL Server / SQL Statistics par journey to sqlauthority

Creating Covering Index to Eliminate Join – SQL in Sixty ...
Last week, I had published Remove Bookmark Lookup – SQL in Sixty Seconds #089 and I got […]

29 juillet 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Index / SQL Joins / SQL Performance / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

SQL SERVER – 7 Follow Up Answers to Remove Bookmark ...
Earlier last week, I published a blog post and SQL in Sixty Seconds video and it got […]

28 juillet 2020 dans Sites anglophones étiqueté SQL Index / SQL Performance / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Free Performance Tuning Videos
Yesterday I wrote a blog post about COVID-19, Working From Home and Performance Tuning and I have […]

21 mars 2020 dans Sites anglophones étiqueté SQL Performance / SQL Video par journey to sqlauthority

SQL SERVER – Scheduler_ID with Large Number in dm_os_schedulers
The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With […]

13 mars 2020 dans Sites anglophones étiqueté CPU Threads / SQL CPU / SQL DMV / SQL Performance / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Query to List Active and Inactive VLF
Recently, I had a very interesting experience with one of my clients where we observed a large […]

12 mars 2020 dans Sites anglophones étiqueté Shrinking Database / SQL Log / SQL Performance / SQL Scripts / SQL Server / SQL Server DBCC / transaction log par journey to sqlauthority

SQL SERVER – Reducing TempDB Recompilation with Fixed Plan
Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health […]

11 mars 2020 dans Sites anglophones étiqueté Execution Plan / Query Hint / SQL Performance / SQL Scripts / SQL Server / SQL TempDB par journey to sqlauthority

SQL SERVER – Remove All Query Cached Plans Not Used ...
One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I […]

7 mars 2020 dans Sites anglophones étiqueté Execution Plan / SQL Cache / SQL DateTime / SQL Function / SQL Performance / SQL Scripts / SQL Server / SQL Server DBCC par journey to sqlauthority

SQL SERVER – TempDB and Trace Flag 1117 and 1118 ...
Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. […]

27 février 2020 dans Sites anglophones étiqueté SQL Performance / SQL Server / SQL TempDB / traceflags par journey to sqlauthority

SQL SERVER – Unable to Allocate Enough Memory to Start ...
One of my clients, contacted me to fix one of the errors which they received while starting […]

24 février 2020 dans Sites anglophones étiqueté In-Memory OLTP / SQL / SQL Error Messages / SQL Performance / SQL Server / Starting SQL par journey to sqlauthority