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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

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

Posted on September 25, 2023

Using WITHIN GROUP to Order STRING_AGG Results

Posted on September 5, 2023

What is the READPAST Query Hint?

Posted on August 15, 2023

Why You Shouldn’t Start Stored Procedures with sp_

Posts pagination

Page 1 Page 2 … Page 6 Next page

Menu

  • Home
  • Blog
  • About
  • Contact

Search

Categories

  • AWS (3)
  • Azure Data Studio (3)
  • Backup/Restore (28)
  • Corruption (10)
  • Execution Plans (38)
  • Failover Clustering (2)
  • Hardware (12)
  • Indexing (29)
  • Joins (3)
  • Locking/Blocking (7)
  • Log Shipping (1)
  • Misc (75)
  • Monitoring (27)
  • MySQL (17)
  • Personal (34)
  • Powershell (21)
  • Python (1)
  • Query Store (4)
  • Query Tuning (59)
  • Security (17)
  • SQL Configuration (82)
  • SQL Server (246)
  • SSMS (144)
  • Statistics (4)
  • T-SQL (161)
  • Uncategorized (2)
  • Updates/Upgrades (28)
  • Wait Stats (5)
  • Workbench (5)

Top Posts

  • Only Focus on A, B, and Z
  • Testing a Power Supply with a Paper Clip
  • The Mystery of Australian Time
  • Using WITHIN GROUP to Order STRING_AGG Results
  • SSMS 20 and Central Management Server Connections
  • Another Availability Group Sync Saga
  • Enabling the MySQL Keyring Plugin
  • XML Compression in SQL Server 2022
  • More Bang for Your Buck with Buffer Pool Extension
  • T-SQL Tuesday #196 - What career risks have you taken?
Create a website or blog at WordPress.com
Chad Callihan
Create a website or blog at WordPress.com
  • Subscribe Subscribed
    • Chad Callihan
    • Join 41 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Chad Callihan
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...