June 2022 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
dmvs

SQL SERVER – Representing sp_who2 with DMVs

December 16, 2020
Pinal Dave
SQL Tips and Tricks
sp_who2, SQL DMV, SQL Performance, SQL Scripts, SQL Server

During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.

Read More
logical order

SQL SERVER – Logical Processing Order of the SELECT Statement

November 18, 2020
Pinal Dave
SQL
Logical Processing Order, SQL Operator, SQL Performance, SQL Scripts, SQL Server

Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.

Read More
TOP and DISTINCT

SQL SERVER – TOP and DISTINCT – Epic Confusion – SQL in Sixty Seconds #141

November 4, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server

DBAs from the client’s organization ended up an argument about how T-SQL works. The discussion was about the epic confusion about TOP and DISTINCT.

Read More
Efficient Query

Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140

October 30, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.

Read More
Outdated Statistics

Find Outdated Statistics – SQL in Sixty Seconds #137

October 22, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Server, SQL Statistics

Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.

Read More
what is edge

What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298

October 18, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Server Management Studio, SSMS

Question: What is EDGE in SQL Server Execution Plan?

Answer: It is the arrow or the line which goes from one operator to another operator.

Read More
Deleted Rows

How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297

October 11, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Delete, SQL Performance, SQL Scripts, SQL Server, SQL Trigger

Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.

Read More
Previous 1 2 3 4 5 6 7 … 21 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2022 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version