SnowPro Core -Snowflake Cloud Data Platform: Features and Architecture, the course offered by Pluralsight, is a comprehensive guide .
SQL SERVER – Understanding Maximum Server Memory
When optimizing your SQL Server for superior performance, understanding and correctly implementing the ‘maximum server memory’ setting is crucial.
Celebrating 17 Years of SQL Authority: A Beautiful Journey of Learning and Sharing
I am feeling very thankful and a bit surprised. It’s been 17 years since I started SQL Authority. This journey was about learning, sharing.
SQL SERVER – Understanding Minimum Server Memory
When configuring your SQL Server for optimal performance, understanding and correctly implementing the ‘minimum server memory’ setting is crucial.
SQL SERVER – An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
This article takes a deep dive into these modifications, with a particular focus on the MIXED_PAGE_ALLOCATION property.
Snowflake’s Pruning Capabilities – Faster Query Performance
In this post, we’ll explore how Snowflake’s pruning features can optimize complex queries for blazing-fast results. Pruning Capabilities
SQL SERVER – Comparing LIKE vs LEFT for Column Comparisons
Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.