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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

Posted on September 2, 2021

Handling Implicit Conversion

Posted on August 25, 2021

Is SET NOCOUNT ON the Answer?

Posted on August 19, 2021

Checking SQL Server Start Time

Posted on August 5, 2021

Indexes and Column Sorting

Posted on August 2, 2021

Dirty Reads and Patience

Posted on July 18, 2021

Tread Carefully With Index Hints

Posted on June 4, 2021

Handling Unused Indexes

Posted on May 30, 2021

Is Dropping a Temp Table in a Stored Procedure Beneficial?

Posted on May 27, 2021

Don’t Sweat the Small Stuff()

Posted on May 2, 2021

Why Do I See ASYNC_NETWORK_IO Waits?

Posts pagination

Previous page Page 1 … Page 4 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
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Forcing Parallelism: Trace Flag vs. Query Hint
  • The Mystery of Australian Time
  • Deciding Cost Threshold for Parallelism
  • Combinations with Cross Join
  • 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...