This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
min server memory

SQL SERVER – Understanding Minimum Server Memory

October 31, 2023
Pinal Dave
SQL Performance
SQL Memory

When configuring your SQL Server for optimal performance, understanding and correctly implementing the ‘minimum server memory’ setting is crucial.

Read More
mixedpageallocation

SQL SERVER – An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation

October 30, 2023
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL TempDB

This article takes a deep dive into these modifications, with a particular focus on the MIXED_PAGE_ALLOCATION property.

Read More
A wardrobe of shirts hung in color order, a hand reaching into one section, a few shirts out of place

Ordered Clustered Columnstore Index for Better Rowgroup Elimination

October 27, 2023
Pinal Dave
SQL Performance
ColumnStore Index, Data Warehousing, SQL Server, SQL Server 2022

Build an ordered clustered columnstore on SaleDate, compare segment ranges and skipped segments, and review how later loads affect order.

Read More
Column Comparisons

SQL SERVER – Comparing LIKE vs LEFT for Column Comparisons

October 26, 2023
Pinal Dave
SQL Performance
SQL Function, SQL Index

Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.

Read More
WHERE clause

SQL SERVER Performance: Functions in WHERE Clause

October 9, 2023
Pinal Dave
SQL Performance
SQL Function, SQL Index

Functions in WHERE clause can hurt performance. I compare a query using YEAR() with one using direct column references on AdventureWorks, plus indexes.

Read More
The Intricacies of T-SQL String Comparison: LIKE VS '='

The Intricacies of T-SQL String Comparison: LIKE VS ‘=’

October 4, 2023
Pinal Dave
SQL Performance
SQL Index, SQL Performance

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.

Read More
temptable

SQL SERVER – Performance: Optimizing High Volume OR Conditions through TempTable

October 2, 2023
Pinal Dave
SQL Performance
SQL Operator, SQL Performance, Temp Table

We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.

Read More
Previous 1 … 3 4 5 6 7 8 9 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com