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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

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 July 3, 2022

Gotcha When Setting Variable

Posted on June 14, 2022

T-SQL Tuesday #151 – T-SQL Coding Standards

Posted on May 2, 2022

Multiple Counts in One Query

Posted on April 26, 2022

Using INSTEAD OF Trigger to Update View

Posted on April 5, 2022

What About Temporary Stored Procedures

Posted on March 31, 2022

Synonyms in SQL Server

Posted on January 31, 2022

Safer Upgrades with Query Store

Posted on November 29, 2021

Hate for Heaps

Posts pagination

Previous page Page 1 Page 2 Page 3 Page 4 … 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

  • Why You Shouldn't Start Stored Procedures with sp_
  • Combine CSV Files Using PowerShell
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • The Mystery of Australian Time
  • Deciding Cost Threshold for Parallelism
  • T-SQL Tuesday #136: Your Favorite or Least Favorite Data Type
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Impact of Automatic Index Compaction
  • Multiple Counts in One Query
  • Remove Duplicate Records in CSV Files with PowerShell
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...