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.
SQL SERVER – Exploring SQL Graph Pattern Matching with MATCH
One of the powerful features of SQL Graph is the ability to search and traverse these graph pattern relationships easily using the MATCH clause.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.