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

SQL Video

Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is […]

2 août 2022 dans Sites anglophones étiqueté SQL Column / SQL in Sixty Seconds / SQL Video par journey to sqlauthority

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

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

Compressed Backup and Performance – SQL in Sixty Seconds #196
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that can […]

12 avril 2022 dans Sites anglophones étiqueté SQL Backup / SQL in Sixty Seconds / SQL Restore / SQL Server / SQL Video par journey to sqlauthority

Split Screen for SSMS Efficiency – SQL in Sixty Seconds ...
I do Comprehensive Database Performance Health Check for living, I work with the SSMS most of the […]

8 septembre 2020 dans Sites anglophones étiqueté SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Nonclustered Primary Key – SQL in Sixty Seconds #119
One of my clients of Comprehensive Database Performance Health Check recently faced a very interesting situation. I […]

7 septembre 2020 dans Sites anglophones étiqueté Primary Key / SQL Constraint and Keys / SQL Index / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Recent Execution of Stored Procedure – SQL in Sixty Seconds ...
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every […]

5 septembre 2020 dans Sites anglophones étiqueté SQL DMV / SQL in Sixty Seconds / SQL Server Management Studio / SQL Stored Procedure / SQL Video / SSMS 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

Recover Crashed Query in SSMS – SQL in Sixty Seconds ...
Has it ever happened to you when you are working on a large SQL Server query and […]

3 septembre 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Server / SQL Server Management Studio / SQL Video / SSMS par journey to sqlauthority

Email an Execution Plan – SQL in Sixty Seconds #114
Most part of my day is spent doing Comprehensive Database Performance Health Check with different organizations. During […]

1 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL in Sixty Seconds / SQL Server / 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

Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. […]

28 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Reports / SQL Scripts / SQL Server / SQL Server Security / SQL Video 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

Undo Human Errors in SQL Server – SQL in Sixty ...
In this blog post, we are going to talk about how to undo human errors in SQL […]

25 août 2020 dans Sites anglophones étiqueté SQL Backup / SQL in Sixty Seconds / SQL Restore / SQL Scripts / SQL Server / SQL Video par journey to sqlauthority

Solve Puzzle about Data type – SQL in Sixty Seconds ...
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged […]

24 août 2020 dans Sites anglophones étiqueté Data Type / SQL in Sixty Seconds / SQL Puzzle / SQL Scripts / SQL Server / SQL Video 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

SQL SERVER – Offline, Detach and Drop – Differences – ...
During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, […]

18 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Scripts / SQL Server / SQL Video / SSMS / System Object par journey to sqlauthority

Are Not Equal to Operators Equal to Not In? – ...
What I love most about my job Comprehensive Database Performance Health Check, is that I get to […]

17 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Operator / SQL Scripts / SQL Server / SQL Video 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

List All Parallel Queries – SQL in Sixty Seconds #098
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query […]

12 août 2020 dans Sites anglophones étiqueté CPU Scheduler / CPU Threads / Parallel / SQL CPU / SQL in Sixty Seconds / 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

Alter Index Add Column – Workaround – SQL in Sixty ...
During the recent Comprehensive Database Performance Health Check, I identified at my client’s place that we needed […]

8 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Index / SQL Scripts / SQL Server / SQL Video / SSMS par journey to sqlauthority

Fastest Way to Retrieve Rowcount for a Table – SQL ...
Whenever I am helping my clients with their SQL Server Performance Comprehensive Database Performance Health Check, every […]

7 août 2020 dans Sites anglophones étiqueté SQL in Sixty Seconds / SQL Scripts / SQL Server / SQL System Table / 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

Quantum Computing With an Example of Coin – SQL in ...
Quantum Computing is the next wave in computing and it is very different from traditional computing. Lots […]

5 août 2020 dans Sites anglophones étiqueté Quantum Computing / SQL Video par journey to sqlauthority

How to Uninstall SQL Server 2019 Instance? – SQL in ...
Earlier this week, I had posted a video about how to install SQL Server 2019. I received […]

3 août 2020 dans Sites anglophones étiqueté SQL Server / SQL Server Configuration / SQL Server Installation / SQL Video par journey to sqlauthority

How to Install SQL Server 2019? – Interview Question of ...
Question: How to Install SQL Server 2019? Answer: This is one of the unique blog posts in […]

2 août 2020 dans Sites anglophones étiqueté SQL Interview Questions and Answers / SQL Server / SQL Server Configuration / SQL Server Installation / SQL Video par journey to sqlauthority

Install MongoDB on Windows – SQL in Sixty Seconds #091
SQL Server is my passion and I have been keeping busy most of the time in my […]

31 juillet 2020 dans Sites anglophones étiqueté MongoDB / MongoDB Atlas / MongoDB Compass / SQL in Sixty Seconds / SQL Video par journey to sqlauthority

SQL in Sixty Seconds – Need Your Feedback
I have been writing about SQL Server Blog for over 13 years now and I have been […]

30 juillet 2020 dans Sites anglophones étiqueté Feedback / SQL Video 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