This blog post aims to shed light on the performance impact between questions that use functions within the WHERE clause.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
Office Hours with Special Host – Brent Ozar
It was a treasure trove of learning experiences. Today, we will discuss Office Hours with Special Host – Brent Ozar.
The Intricacies of T-SQL String Comparison: LIKE VS ‘=’
Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries.
TempDB Troubles: Identifying and Resolving TempDB Contentions
(SQL DM) provides superior monitoring capabilities to streamline tempdb performance. We will discuss Identifying and Resolving TempDB Contentions.
SQL SERVER – Performance: Optimizing High Volume OR Conditions through TempTable
We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY
In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.
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.