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

Chad Callihan

A Blog for Databases and More

  • LinkedIn
  • Twitter
  • Instagram

Category: Query Tuning

Posted on March 27, 2021

Estimated and Actual Execution Plans

Posted on March 20, 2021

Avoiding SQL Injection

Posted on March 17, 2021

Load Testing with SqlQueryStress

Posted on February 24, 2021

Handling Divide By Zero Error

Posted on February 20, 2021

Do You Really Need that Order By?

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 December 29, 2020December 28, 2020

Don’t Overuse DEADLOCK_PRIORITY

Posted on December 5, 2020December 20, 2020

Set Statistics Time/IO For Each New Query Window

Posts pagination

Previous page Page 1 … Page 5 Page 6

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

  • Querying XML Data in SQL Server
  • Combine CSV Files Using PowerShell
  • Retrieving SQL View Definitions
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • Restarting Database Mail When it Stops
  • Upgrading After Evaluation Edition Expires
  • Options for Creating Mock Data
  • Viewing Deadlock Graphs
  • Adding tempdb Files
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