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 (71)
  • Monitoring (27)
  • MySQL (16)
  • Personal (31)
  • 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
  • Why Did Query Store Switch to READ_ONLY?
  • Querying XML Data in SQL Server
  • Finding All Database Sizes on a SQL Server
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Inserting and Exporting MySQL Values with PowerShell
  • Combine CSV Files Using PowerShell
  • Use sp_ineachdb Instead of sp_MSforeachdb
  • The Three Search Modes of MySQL FULLTEXT Indexes
  • Handling NULL with NULLIF and ISNULL
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