Question: What is Full Outer Join With Exclusion?
Answer: I got this question after reading my earlier blog post about Basic of JOINs.
Remove Bookmark Lookup – SQL in Sixty Seconds #089
We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
SQL Azure – Add IP Address to Firewall
To Add IP Address to Firewall rules, I first confirm the intended Azure SQL network path. A home connection prompted this walkthrough.
How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285
Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?
Answer: Actually, I got this question from my client.
SQL SERVER – Boost SQL Server Priority and SSMS 18
Boost SQL Server Priority appeared in the historical SSMS 18.5.1 interface. I showed where to inspect that engine setting.
Identify Index Used for Query – SQL in Sixty Seconds #088
How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
Finding Queries the Application Cancelled With Attention Events
Capture attention events for canceled requests, read event-file XML, compare Query Store aborts, and inspect transaction cleanup.