Skip to content
Chad Callihan
  • Home
  • Blog
  • About
  • Contact

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

Posted on August 11, 2026

T-SQL Tuesday #201 – Temp Data

Posted on July 14, 2026

T-SQL Tuesday #200 – Signs of a Bad Query

Posted on April 15, 2026

RegEx Arrives in SQL Server 2025

Posted on May 4, 2024

What is the OPTION (FAST N) Query Hint?

Posted on April 20, 2024

Finding Positions with CHARINDEX() and PATINDEX()

Posted on February 7, 2024

Latches and Locks Are Not the Same

Posted on February 1, 2024

What is Join Elimination?

Posted on December 26, 2023December 27, 2023

Forcing Parallelism: Trace Flag vs. Query Hint

Posted on November 14, 2023

T-SQL Tuesday #168 – Example Using LEAD

Posted on October 24, 2023

Using CAST and CONVERT Functions with Dates

Posts pagination

Page 1 Page 2 … Page 7 Next page

Menu

  • Home
  • Blog
  • About
  • Contact

Search

Categories

  • AWS (3)
  • Azure Data Studio (3)
  • Backup/Restore (28)
  • Corruption (11)
  • Execution Plans (38)
  • Failover Clustering (2)
  • Hardware (12)
  • Indexing (31)
  • Joins (3)
  • Locking/Blocking (7)
  • Log Shipping (1)
  • Misc (79)
  • Monitoring (27)
  • MySQL (17)
  • Personal (35)
  • Powershell (21)
  • Python (2)
  • Query Store (4)
  • Query Tuning (62)
  • Security (17)
  • SQL Configuration (87)
  • SQL Server (260)
  • SSMS (146)
  • Statistics (5)
  • T-SQL (169)
  • Uncategorized (2)
  • Updates/Upgrades (34)
  • Wait Stats (5)
  • Workbench (5)

Top Posts

  • Combine CSV Files Using PowerShell
  • Why You Shouldn't Start Stored Procedures with sp_
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • The Mystery of Australian Time
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Deciding Cost Threshold for Parallelism
  • Impact of Automatic Index Compaction
  • Multiple Counts in One Query
  • Remove Duplicate Records in CSV Files with PowerShell
  • T-SQL Tuesday #136: Your Favorite or Least Favorite Data Type
Create a website or blog at WordPress.com
Chad Callihan
Create a website or blog at WordPress.com
  • Subscribe Subscribed
    Chad Callihan
    Join 42 other subscribers

    Have a WordPress.com account? Log in now.

  • Chad Callihan
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar
Loading Comments...