seen from Indonesia
seen from Germany
seen from Malaysia
seen from Malaysia
seen from South Korea
seen from Singapore
seen from Malaysia
seen from Canada
seen from China
seen from Malaysia
seen from Bangladesh
seen from Malaysia
seen from Australia
seen from Malaysia
seen from Italy
seen from Japan
seen from Japan
seen from Taiwan
seen from Canada
seen from Belarus
Unlocking the Secrets of SQL Server Memory Grants
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,…
View On WordPress
Why Scalar UDFs Appear in Estimated but Not Actual Query Plans in SSMS
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…
View On WordPress
Good things should be appreciated–SQL sentry Plan Explorer TIP #95
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…
View On WordPress
Boost query performance with avoiding basic mistake with Select statement. Performance Tip – #42
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…
View On WordPress
Cleaning up the Buffer Pool
Chances are you have extra information in the buffer pool for a bad query and it’s dragging down…
View Post
