Recently, I was working on one of the performance tuning assignment with an esteemed client. The size of their databases were growing tremendously. Growth in the database size is directly proportionate to disk space requirement. More the database size will be, more disk space will be required. When we talk about the disk space for … Continue reading Find columns with NULL values across the table
Tracking costliest queries
Being a Database Developer or Administrator, often we work on Performance Optimization of the queries and procedures. It becomes very necessary that we focus on the right queries to get major benefits. Recently I was working on a Performance Tuning project. I started working based on query list provided by client. Client was referring the … Continue reading Tracking costliest queries
Probing Columnstore Indexes
This article was first published on: 2020-03-14. This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics. We'll cover examples from each of the followings - Pivot, Aggregate Functions, Analytic Functions, Ranking Functions and Window Functions.
Clustered Index Key – Natural or Surrogate?
This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of an experiment.
COVID-19, a wake-up call
COVID-19 is the only pandemic I've seen in my whole life. It gave me a whole new percepective of the life. Kaal (Time) is mightiest of everyone and everything. We occasionally forget this when we are in good times. For Kaal everyone is equal. Be it poor, be it rich or be it king. No-one … Continue reading COVID-19, a wake-up call
SQL Server Carpenter 