Query to list all the procedures and triggers not having SET NOCOUNT ON defined

It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...

T-SQL query to find the list of objects referring Linked Servers

T-SQL query to find the list of objects referring Linked Servers

T-SQL script to find hierarchy of tables – Row-wise result

As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to...

T-SQL script to find hierarchy of tables – Columnar result

One of my LinkedIn connection reached out to me for help, to find the hierarchy of all the tables in a database. He was in dire need of some...

Game changer settings # MAXDOP and Cost threshold for parallelism

I got a performance tuning assignment for an esteemed customer in the Financial Services domain. I went through the wait stats of SQL Server using the built-in SQL Server...

Storage savings with Table Compression

In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made...

Estimating the storage savings by removing columns with NULL value across the table or marking them as SPARSE

In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with NULL value across the table...

Find columns with NULL values across the table

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...

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...

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...