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

Chad Callihan

A Blog for Databases and More

  • LinkedIn
  • Twitter
  • Instagram

Category: Indexing

Posted on June 22, 2021

Corrupting a Database For Fun

Posted on June 4, 2021

Handling Unused Indexes

Posted on March 27, 2021

Estimated and Actual Execution Plans

Posted on March 9, 2021

T-SQL Tuesday #136: Your Favorite or Least Favorite Data Type

Posted on February 17, 2021

Utilizing Indexes When Search Text Begins with a Wildcard

Posted on February 12, 2021

Break the Habit of SELECT *

Posted on January 8, 2021

Missing Index Recommendation Column Order

Posted on January 5, 2021January 5, 2021

Estimate Compression with sp_estimate_data_compression_savings

Posted on December 29, 2020December 28, 2020

Don’t Overuse DEADLOCK_PRIORITY

Posts pagination

Previous page Page 1 Page 2 Page 3

Menu

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

Search

Categories

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

Top Posts

  • Retrieving SQL View Definitions
  • Combine CSV Files Using PowerShell
  • Querying XML Data in SQL Server
  • Viewing Deadlock Graphs
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Using INSTEAD OF Trigger to Update View
  • Handling NULL with NULLIF and ISNULL
  • Finding All Database Sizes on a SQL Server
  • Testing a Power Supply with a Paper Clip
  • Updating dbatools
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