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 to use NOT IN, LEFT JOIN, EXCEPT and NOT EXIST effectively

Microsoft SQL Server provides a lot of statements to find what data is existed in A set but not in B set such as NOT IN, LEFT JOIN, EXCEPT and NOT EXISTS. The question is when we use these statements and which is the best performance in case we execute it on a large data set. In … Continue reading How to use NOT IN, LEFT JOIN, EXCEPT and NOT EXIST effectively

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?