In a casual conversation with team, one of my junior team members asked, "If I execute the same query changing the parameter, will the execution plan change?" I thought for some moments and explained him.
[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]
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]
Today, I am going to explain you Clustered Columnstore Index and some related concepts. As a Database enthusiastic, you should know it.
[More]
Today I am going to show you how to import data from a CSV file using Transact-SQL BULK INSERT and the OPENROWSET(BULK...) statement.
[More]
Let's examine the error handling step-by-step.
[More]
This article explain how to store crucial data in SQL server securely.
[More]