Nice article Steve ! The concept is very clearly explained in the right order.

I think if you can also add the "Disclaimer" which is a must I feel then the...

Dear Brahmanand Shukla,  thank you for your kind help!

I meant I encoded 2 SQL statements to get the same result ,  if the numbers of physical reads plus  its...

Logical Reads means reading from Memory and Physical Reads means reading from Disk. Physical Reads involves Disk IO and requires more CPU and processing time to load the Pages in...

I was talking about this. I hope you will find something useful here.

https://sqlsunday.com/2018/08/09/parallel-and-serial-operators/

Although you have a simple SELECT but if you have used SORT operation in the the...

I'm not sure if this will help you. I've seen many properties in Connection, Control Flow, Data Flows and Tasks which you can also explore. There must be some property...

There must be something in your query which is causing the plan to run sequential even if you have forced parallelism.

There are few features which can be run only sequential....

You can't control SQL Query Processing unless you use Query Hints, Table Hints or specifically ask SQL Server Engine to do something. Query Optimizes choose best plan by its own...

Nicely explained Grant !

In addition to what you mentioned, I would like to add more point.

One of the top contributor to poor performance of the query is high number of...

You can achieve faster INSERT with TABLOCK since it would avoid the blockage due to Read and Shared Locks but you cannot achieve the concurrency in insert into destination table.

If...

In figure 1, there are SQL statements , these 2 sql statments join 2 tables, one is on current database server, the other is on another database server. the...

Hi all!

I need help to get the performance up on my ETL. My data flow task is very simple in nature:

<li style="list-style-type: none;">

1. OLE DB source (MS SQL...

Appreciate the efforts to make such an useful repository! I'm going to give it a 5 Stars and will add this in my briefcase.

Kudos !!!

Tracing the error :

1. Checkout this Microsoft Fix if you have SQL Server 2016 and compatibility level set to 130 .
2. You can take help of trace flag. In...

I am working with a table that I have not seen before, and do not have a clear idea on what it is doing or what the data in...

Which version did you installed? Was that Client or Server?