27. November 2024
Mehedi
SQL Server
tempdb is the unsung hero of SQL Server, silently powering temporary tables, internal operations, and session-specific tasks. Understanding how it works and how to optimize it is crucial for maintaining performance and avoiding bottlenecks in your SQL Server environment.
[More]
14. November 2024
Mehedi
SQL Server
Today, I am going to share how can you boost your database performance to new heights with SQL Server memory-optimized tables! Designed for speed and efficiency, these tables redefine data processing by keeping critical data in memory for blazing-fast results.
[More]
Hi everyone, I will share a recent experience. How my team resolved sudden CPU spike!
[More]
Do you know SQL Server keeps an inventory of your SQL queries, where you could track performance, pinpoint bottlenecks, and instantly access the history of every executed query. Even you could force a regressed query to use its previous plan! That is the power of SQL Query Store. The built-in performance tuning tool that provides deep insights into query performance over time. In this article, you will see how Query Store can be used to troubleshoot and optimize your query performance.
[More]
Recently, some indexes of my production server were fragmented frequently. In this article, I am going to tell you how did I sort out the issue.
[More]
My learning from recent incident is "Before scripting database objects, always check the Script indexes options".
[More]
12. September 2024
Mehedi
SQL Server
Query optimizer depends on statistics to estimate the cardinality or number of rows of a query result. In other words, it is the knowledge of how many rows are in a table, and how many of those rows satisfy the various search and join conditions, and so on. Based on this, optimizer creates the best query plan. Sometimes, tweaking the statistics helps to produce efficient query plan. In this article, we are going to explore the fundamentals of SQL Server statistics.
[More]
In the previous article, you learnt about concepts of execution plan, operators, and their properties. In this article, you will learn about reading an execution plan.
[More]
When a query performs poorly and you fails to understand the reason behind it. You need to check the execution plan. However, reading an execution plan is like reading a new language. You need to understand the operators, their properties, data flows, meaning of icons, order of operators etc. In this article series, I am going to discuss this step by step.
[More]
That day one of my junior colleague rushed to me and sought my assistance. He failed to drop an user. It showed - "The database principal owns a schema in the database, and cannot be dropped." I took him to our office kitchen, had tea, and explained the issue.
[More]