#query plan

Introduction Have you ever looked at an actual query plan in SQL Server and wondered what that “MemoryGrant” property is all about? 🤔 You’re not alone! As a DBA, I remember being puzzled by this mysterious value when I first started digging into execution plans. But fear not, dear reader – by the end of this article, you’ll be a MemoryGrant master! 💪 We’ll dive deep into what memory grants are,…

Introduction Have you ever noticed that when you view query plans in SQL Server Management Studio (SSMS), scalar user-defined functions (UDFs) appear in the estimated plan but mysteriously vanish from the actual plan? In this article, we’ll explore the reasons behind this behavior and discuss its implications for query optimization and performance. Understanding Scalar UDFs Scalar UDFs are…

Good things should be appreciated–SQL sentry Plan Explorer TIP #95

Although , It is out of box but I would like to share here. I am very choose in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn’t like but when food taste was awesome then I didn’t say a word.

My mother taught me “You should appreciate every thing which is good.” You’re single appreciation word do things

1. You feel yourself better

2. The person…

Boost query performance with avoiding basic mistake with Select statement. Performance Tip – #42

  Problem:-

My query is slow what are the basic things I can do to get good performance without going for indexes.

Solution:-

May be this solution help you which I am describing here or it is possible you already aware of it.

  (a) Avoid function in column :-The most basic tip is avoid any function in where clause which applied on table column.

lets understand this by few examples

Suppose your…

Cleaning up the Buffer Pool

Chances are you have extra information in the buffer pool for a bad query and it’s dragging down…