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?
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, EXCEP 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
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?