How to choose query type (nested or join)?

Question

Transact SQL

Good afternoon, I'm studying nested queries, which in some cases are easily replaced by joining tables. How to determine which type to use?
Example

SELECT orderid
FROM Sales.Orders
WHERE empid IN
(SELECT E.empid
FROM HR.Employees AS E
WHERE E.lastname LIKE N'Д%');

VS

SELECT O.orderid
FROM HR.Employees AS E
JOIN Sales.Orders AS O
ON E.empid = O.empid
WHERE E.lastname LIKE N'Д%'

Answer 1

enable statistics display - for I/O operations - runtime statistics. and execute both requests in turn on the messages tab in ssms statistics will be displayed. By comparing, you can choose the query that requires the least amount of disk or processor resources
set statistics io on
set statistics time on