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