How to configure TempDb effectively?

TempDb is one of the critical databases of Microsoft SQL Server. It is used for many purposes Temporary user objects Table variables Temporary tables Cursor Temporary procedures Global temporary tables Intermediate results, work files and work tables  Sort Rebuild Index Group By, Order By Hash Join and Hash Aggregates Spills to tempdb Temporary LOB storage … Continue reading How to configure TempDb effectively?

Advertisements

TSQL: How to delete large volume data quickly

A couple of weeks, my friends asked me the best suitable approach to move data out a large table. I was interested in this question because there was no right answers. Depending on the situation, environment even database structure to determine what approaches. Actually, there are a lot of techniques you can apply how to delete data … Continue reading TSQL: How to delete large volume data quickly

How to convert a rowstore table to columnstore table?

Introduction In this article , I introduced one of fantastic features of Microsoft COLUMNSTORE and had a comparison between a rowstore table and a columnstore table. The result was very interesting. However, if your table is in rowstore style, how we can convert a rowstore to columnstore Solution Converting a rowstore , there are two cases … Continue reading How to convert a rowstore table to columnstore table?

Should be careful when shrinking your database on LIVE environment

Today, I would like to tell you the pain story that I have encountered on LIVE environment. A couple of days ago, I received a request from my client. They needed to restore a database and then run some updates on the database. The database contained data of 8 years from 2009 to 2016. However, they … Continue reading Should be careful when shrinking your database on LIVE environment

SQL Server Replication – Merge Replication type step by step

In my previous article, I talked about transactional replication and presented an example of how to configure and use it. Today, I'm going to investigate the second type of replication called Merge Replication. Definition and Mechanism Merge replication allows two or more databases to be kept in sync. Whenever changes happen on one database, they are … Continue reading SQL Server Replication – Merge Replication type step by step

SQL Server Replication – Transactional Replication type step by step

In previous article, I talked about basic concepts and terms of replication using SQL Server. Now, we're going to investigate one of replication types that is called transactional replication. How do we configure this type? When will we use it? Definition and mechanism Transactional replication copies data uni-directionally from the source database to the target database. … Continue reading SQL Server Replication – Transactional Replication type step by step