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

SQL Scripts

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

SQL SERVER – Find Owner of Database – Change Owner ...
Recently I had the opportunity to help a client with Comprehensive Database Performance Health Check, and while […]

3 mai 2022 dans Sites anglophones étiqueté SQL Scripts / SQL Server / SQL Server Security / SQL Tips and Tricks par journey to sqlauthority

SQL SERVER – Sample Script for Compressed and Uncompressed Backup
During Comprehensive Database Performance Health Check, I was recently asked if I have a handy script that […]

21 mars 2022 dans Sites anglophones étiqueté SQL Backup / SQL Scripts / SQL Server / SQL Tips and Tricks 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

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

Activity Monitor and Running Query – SQL in Sixty Seconds ...
Activity Monitor can come handy when you are in trouble as well. In this video, we will […]

2 septembre 2020 dans Sites anglophones étiqueté Execution Plan / SQL Activity Monitor / SQL in Sixty Seconds / SQL Scripts / SQL Server / SQL Tips and Tricks par journey to sqlauthority

What Happens If the Clustered Index is Disabled? – Interview ...
Question: What Happens If the Clustered Index is Disabled? Answer: If you disable the clustered index, you […]

30 août 2020 dans Sites anglophones étiqueté Clustered Index / SQL Error Messages / SQL Index / SQL Interview Questions and Answers / SQL Scripts / SQL Server 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

How to Insert Multiple Values into Multiple Tables in a ...
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? Answer: One of the […]

23 août 2020 dans Sites anglophones étiqueté Execution Plan / SQL Interview Questions and Answers / SQL Scripts / SQL Server 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 – 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

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

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

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

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

SQL SERVER 2019 – Disabling Scalar UDF Inlining
I have been blogging for over 13 years and have been working with SQL Server Performance Tuning […]

1 août 2020 dans Sites anglophones étiqueté SQL Function / SQL Scripts / SQL Server / SQL Server 2019 / SQL Tips and Tricks 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 – Finding Day Name from Date
In today’s blog post we will a very simple script where we will find day name from […]

27 juillet 2020 dans Sites anglophones étiqueté SQL DateTime / SQL Function / SQL Scripts / SQL Server / SQL Tips and Tricks par journey to sqlauthority

What is Full Outer Join With Exclusion? – Interview Question ...
Question: What is Full Outer Join With Exclusion? Answer: I got this question after reading my earlier […]

26 juillet 2020 dans Sites anglophones étiqueté SQL Interview Questions and Answers / SQL Joins / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Error 9002: The Transaction Log for Database ...
Recently one of my clients contacted me to provide them assistance in finding and fixing the cause […]

23 mars 2020 dans Sites anglophones étiqueté SQL / SQL Error Messages / SQL Log / SQL Replication / SQL Scripts / SQL Server / transaction log par journey to sqlauthority

What is the Difference Between sql_handle and plan_handle?- Interview Question ...
Question: What is the Difference Between sql_handle and plan_handle? Answer: I was recently asked this question during […]

22 mars 2020 dans Sites anglophones étiqueté SQL Cache / SQL DMV / SQL Interview Questions and Answers / SQL Memory / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Msg 1842 – The File Size, Max ...
One of my clients contacted me for assistance with whom I worked earlier to perform a Comprehensive […]

19 mars 2020 dans Sites anglophones étiqueté File Growth / SQL Error Messages / SQL FileGroup / SQL Log / SQL Scripts / SQL Server / SQL Server Configuration / SQL Tips and Tricks par journey to sqlauthority

SQL SERVER – Why Server Authentication is Disabled? What Mode ...
Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software […]

18 mars 2020 dans Sites anglophones étiqueté SQL / SQL Error Messages / SQL Scripts / SQL Server / SQL Server Configuration / SQL Server Security par journey to sqlauthority

SQL SERVER – PolyBase Error Msg 46530 – External Data ...
While trying to try PolyBase on my laptop, I was getting an error. When I looked further, […]

16 mars 2020 dans Sites anglophones étiqueté Polybase / SQL / SQL Error Messages / SQL Scripts / SQL Server / SQL Server Configuration par journey to sqlauthority

How to Decode @@OPTIONS Value? – Interview Question of the ...
There are situations where set options can change the query behavior of a session. The session-level options […]

15 mars 2020 dans Sites anglophones étiqueté SQL Interview Questions and Answers / SQL Options / SQL Scripts / SQL Server 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

How to Do Case Insensitive Search? – Interview Question of ...
Question: How to Do Case Insensitive Search? Answer: This is a very interesting question. Most of the […]

8 mars 2020 dans Sites anglophones étiqueté SQL Collation / SQL Interview Questions and Answers / SQL Scripts / SQL Search / SQL Server 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 Management Studio – Rebuild All Indexes on Table
Today, we are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where […]

6 mars 2020 dans Sites anglophones étiqueté SQL Index / SQL Scripts / SQL Server / SQL Server Management Studio / SQL Tips and Tricks / SSMS par journey to sqlauthority

SQL SERVER – Count NULL Values From Column
The other day, I have received a very simple but interesting question by one of my earlier […]

5 mars 2020 dans Sites anglophones étiqueté SQL Function / SQL NULL / SQL Scripts / SQL Server / SQL Tips and Tricks par journey to sqlauthority

SQL SERVER – Truncating Data and ANSI_WARNINGS
Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Database […]

3 mars 2020 dans Sites anglophones étiqueté SQL Error Messages / SQL Scripts / SQL Server / SQL Server 2019 / SQL Tips and Tricks / Temp table par journey to sqlauthority

SQL SERVER – SELECT INTO a Table Variable in T-SQL
Recently one of my oldest clients of Comprehensive Database Performance Health Check asked me a very interesting […]

2 mars 2020 dans Sites anglophones étiqueté SQL Scripts / SQL Server / SQL Table Operation / SQL Tips and Tricks / Temp table par journey to sqlauthority

How to Join Two Tables Without Using Join Keywords? – ...
Question: How to Join Two Tables Without Using Join Keywords? Answer: In my life, I have attended […]

1 mars 2020 dans Sites anglophones étiqueté SQL Interview Questions and Answers / SQL Joins / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Displaying Smiley in SSMS – Emoji
Recently I had an interesting conversation with my client about Emoji in SQL Server. The question from […]

28 février 2020 dans Sites anglophones étiqueté emoji / SQL Scripts / SQL Server / SQL Server Management Studio / SQL Tips and Tricks / SSMS par journey to sqlauthority

SQL SERVER – Error 15580 – Cannot Drop Master Key ...
Sometimes I get amazed by the speed at which the search engine crawls and gets the right […]

26 février 2020 dans Sites anglophones étiqueté Service Broker / SQL / SQL Error Messages / SQL GUID / SQL Scripts / SQL Server / SQL Server Encryption / SQL Server Security par journey to sqlauthority

How to Forecast the Size of Restore of Backup in ...
Question: How to Forecast the Size of Restore of Backup in SQL Server? Answer: Recently, I had […]

23 février 2020 dans Sites anglophones étiqueté SQL Backup / SQL Interview Questions and Answers / SQL Restore / SQL Scripts / SQL Server par journey to sqlauthority

SQL SERVER – Always On Error: This Database is Encrypted ...
As a part of my work, I also provide consultancy to fix the issues. It has three […]

22 février 2020 dans Sites anglophones étiqueté AlwaysOn / SQL / SQL Error Messages / SQL Scripts / SQL Server / SQL Server Encryption / SQL Server Security par journey to sqlauthority