Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
Rewriting Correlated Subqueries as Window Functions
Replace correlated subqueries with windowed counts, dates, and running totals, preserve detail rows, and keep useful EXISTS filters.
Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140
Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.
SQL SERVER – Fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached
When we tried to run a few of their stored procedure. How we can fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached.
Scan Count Zero in STATISTICS IO: What the Number Means
Scan count zero in STATISTICS IO is not an error and not a free read. This post runs nine small queries and shows what 0, 1, 2 and 5 mean, why a unique lookup counts as zero, and why logical reads are the number to compare.
SET STATISTICS TIME ON – SQL in Sixty Seconds 139
Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.
Alerting on Long-Running Queries With a SQL Agent Job
Alert on long-running queries with a five-minute SQL Agent job, a deduplicated log, and one Database Mail notice per new request.