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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

Posted on April 1, 2021

April Fools’ Day SQL Pranks

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

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 (76)
  • Monitoring (27)
  • MySQL (17)
  • Personal (34)
  • Powershell (21)
  • Python (1)
  • Query Store (4)
  • Query Tuning (60)
  • Security (17)
  • SQL Configuration (82)
  • SQL Server (248)
  • SSMS (144)
  • Statistics (4)
  • T-SQL (163)
  • Uncategorized (2)
  • Updates/Upgrades (29)
  • Wait Stats (5)
  • Workbench (5)

Top Posts

  • The Mystery of Australian Time
  • Finding All Database Sizes on a SQL Server
  • Combine CSV Files Using PowerShell
  • Retrieving SQL View Definitions
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • Upgrading After Evaluation Edition Expires
  • Stolen Memory in SQL Server
  • Updating dbatools
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Troubleshooting an Always Encrypted Certificate Error
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