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
Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY.

SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY

September 29, 2023
Pinal Dave
SQL Performance
Shrinking Database, SQL Server DBCC

In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.

Read More
CHARINDEX

SQL SERVER – A Comparison of CHARINDEX vs LIKE

September 26, 2023
Pinal Dave
SQL Performance
SQL Function, SQL Performance, SQL String

In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.

Read More
Incremental Statistics

SQL SERVER – Understanding Incremental Statistics

September 19, 2023
Pinal Dave
SQL Performance
SQL Index, SQL Statistics

Understanding incremental statistics: since SQL Server 2014, statistics can update only the changed subsets instead of a costly full scan on large tables.

Read More
A huge roasting tray in an open oven holding one small sausage in the middle.

Oversized varchar Columns and Inflated Memory Grants

September 18, 2023
Pinal Dave
SQL Performance
Execution Plan, SQL Datatype, SQL Memory, SQL Performance, SQL Server

Investigate oversized varchar declarations, compare sort memory grants, and narrow string columns safely without losing valid data.

Read More
WHERE clause

SQL SERVER – Avoid Functions in the WHERE Clause for Performance

September 13, 2023
Pinal Dave
SQL Performance
SQL Function, SQL Performance

Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.

Read More
brent pinal

SQL SERVER – Performance: OR vs IN – A Summary and Further Reading

September 12, 2023
Pinal Dave
SQL Performance
Clustered Index, Computed Column, SQL Index, SQL Server

The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.

Read More
SQL SERVER - Performance: OR vs IN

SQL SERVER – Performance: OR vs IN

September 11, 2023
Pinal Dave
SQL Performance
Execution Plan, SQL Server Management Studio, SQL Statistics

I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.

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

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