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

Chad Callihan

A Blog for Databases and More

  • LinkedIn
  • Twitter
  • Instagram

Category: Execution Plans

Posted on February 1, 2024

What is Join Elimination?

Posted on August 15, 2023

Why You Shouldn’t Start Stored Procedures with sp_

Posted on June 13, 2023

T-SQL Tuesday Throwback

Posted on February 28, 2023

Save Time Counting, Use IF EXISTS

Posted on February 14, 2023

T-SQL Tuesday #159 – Optimizing for the Year

Posted on January 2, 2023

Considerations for Updated Statistics

Posted on December 21, 2022

Options to Compare Table Records

Posted on October 25, 2022

The Rivalry Between SELECT INTO and INSERT INTO

Posted on September 19, 2022

The Eager Index Spool aka The Spiteful Spool

Posted on August 29, 2022

Turning Indexes Invisible in MySQL

Posts pagination

Page 1 Page 2 … Page 4 Next page

Menu

  • Home
  • Blog
  • About
  • Contact
  • LinkedIn
  • Twitter
  • Instagram

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 (74)
  • Monitoring (27)
  • MySQL (17)
  • Personal (33)
  • 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

  • Finding All Database Sizes on a SQL Server
  • Combine CSV Files Using PowerShell
  • Retrieving SQL View Definitions
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Restarting Database Mail When it Stops
  • Querying XML Data in SQL Server
  • Resolving Login SID Mismatches
  • Querying SQL Backup History
  • Trusting the TRUSTWORTHY Property
  • UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING Examples
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...