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

Chad Callihan

A Blog for Databases and More

Category: Query Tuning

Posted on September 25, 2023

Using WITHIN GROUP to Order STRING_AGG Results

Posted on September 5, 2023

What is the READPAST Query Hint?

Posted on August 15, 2023

Why You Shouldn’t Start Stored Procedures with sp_

Posted on May 30, 2023

Why Use QUOTENAME?

Posted on May 1, 2023

What are Sparse Columns?

Posted on February 28, 2023

Save Time Counting, Use IF EXISTS

Posted on October 25, 2022

The Rivalry Between SELECT INTO and INSERT INTO

Posted on September 27, 2022

Pagination Options in SQL Server

Posted on September 19, 2022

The Eager Index Spool aka The Spiteful Spool

Posted on September 3, 2022

Use sp_ineachdb Instead of sp_MSforeachdb

Posts pagination

Previous page Page 1 Page 2 Page 3 … 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
  • Using WITHIN GROUP to Order STRING_AGG Results
  • Deciding Cost Threshold for Parallelism
  • Impact of Automatic Index Compaction
  • Multiple Counts in One Query
  • Remove Duplicate Records in CSV Files with PowerShell
  • T-SQL Tuesday #136: Your Favorite or Least Favorite Data Type
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...