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

How does COLUMNSTORE INDEXES improve performance of Data Warehouse?

Introduction From SQL Server 2012, Microsoft released one of the most important features for querying a large dataset COLUMNSTORE INDEXES. The columnstore index is the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse … Continue reading How does COLUMNSTORE INDEXES improve performance of Data Warehouse?