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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

Posted on April 25, 2021

What is a Read-Ahead Read?

Posted on April 22, 2021

Delete vs. Truncate

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 *

Posts pagination

Previous page Page 1 … Page 5 Page 6 Page 7 Next page

Menu

  • Home
  • Blog
  • About
  • Contact

Search

Categories

  • AWS (3)
  • Azure Data Studio (3)
  • Backup/Restore (28)
  • Corruption (11)
  • Execution Plans (38)
  • Failover Clustering (2)
  • Hardware (12)
  • Indexing (31)
  • Joins (3)
  • Locking/Blocking (7)
  • Log Shipping (1)
  • Misc (79)
  • Monitoring (27)
  • MySQL (17)
  • Personal (35)
  • Powershell (21)
  • Python (2)
  • Query Store (4)
  • Query Tuning (62)
  • Security (17)
  • SQL Configuration (87)
  • SQL Server (260)
  • SSMS (146)
  • Statistics (5)
  • T-SQL (169)
  • Uncategorized (2)
  • Updates/Upgrades (34)
  • Wait Stats (5)
  • Workbench (5)

Top Posts

  • Why You Shouldn't Start Stored Procedures with sp_
  • Combine CSV Files Using PowerShell
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • The Mystery of Australian Time
  • Deciding Cost Threshold for Parallelism
  • T-SQL Tuesday #136: Your Favorite or Least Favorite Data Type
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Impact of Automatic Index Compaction
  • Multiple Counts in One Query
  • Remove Duplicate Records in CSV Files with PowerShell
Create a website or blog at WordPress.com
Chad Callihan
Create a website or blog at WordPress.com
  • Subscribe Subscribed
    Chad Callihan
    Join 42 other subscribers

    Have a WordPress.com account? Log in now.

  • Chad Callihan
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar
Loading Comments...