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

Chad Callihan

A Blog for Databases and More

Category: Indexing

Posted on March 22, 2025

The Three Search Modes of MySQL FULLTEXT Indexes

Posted on February 21, 2024

Transaction Log Growth During Index Rebuilds

Posted on February 28, 2023

Save Time Counting, Use IF EXISTS

Posted on February 6, 2023

OPTIMIZE_FOR_SEQUENTIAL_KEY – The Key to Success?

Posted on September 19, 2022

The Eager Index Spool aka The Spiteful Spool

Posted on August 29, 2022

Turning Indexes Invisible in MySQL

Posted on August 23, 2022

Trivial Plans Are Not Always the Best Plans

Posted on August 9, 2022

Are Forced Plans Always Forced?

Posted on November 29, 2021

Hate for Heaps

Posted on November 22, 2021

Sargable Dates Example

Posts pagination

Page 1 Page 2 Page 3 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
  • Upgrading After Evaluation Edition Expires
  • Combine CSV Files Using PowerShell
  • Testing a Power Supply with a Paper Clip
  • The Mystery of Australian Time
  • Retrieving SQL View Definitions
  • Update Job Step Across Multiple SQL Servers
  • T-SQL Tuesday #196 - What career risks have you taken?
  • Another Availability Group Sync Saga
  • Enabling the MySQL Keyring Plugin
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...