Efficient query writing

Accepted answer

Please have a look at this:

Query Tuning with SQL Server 2019 (sqlshack.com)

+2

Hi Graeme Pariot, You should also read these articles.

https://www.codingvila.com/search/label/Performance%20Tuning

https://www.codingvila.com/2019/02/sql-server-basic-berformance-tuning-tips-and-tricks.html

+1

Practise is all you need but even after writing thousands of queries you can't label yourself as perfect in anything.

however you should always try to write well performing queries

https://stackify.com/performance-tuning-in-sql-server-find-slow-queries/

+2

Thanks Mam, I'll go through it.

+1