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

Chad Callihan

A Blog for SQL Server and More

  • LinkedIn
  • Twitter
  • Instagram

Category: Indexing

Posted on February 28, 2023

Save Time Counting, Use IF EXISTS

Posted on February 6, 2023

OPTIMIZE_FOR_SEQUENTIAL_KEY – The Key to Success?

Posted on September 19, 2022

The Eager Index Spool aka The Spiteful Spool

Posted on August 29, 2022

Turning Indexes Invisible in MySQL

Posted on August 23, 2022

Trivial Plans Are Not Always the Best Plans

Posted on August 9, 2022

Are Forced Plans Always Forced?

Posted on November 29, 2021

Hate for Heaps

Posted on November 22, 2021

Sargable Dates Example

Posted on November 19, 2021

Non-Sargable is Self Sabotage

Posted on November 8, 2021November 7, 2021

Views vs. Indexed Views

Posts navigation

Page 1 Page 2 Page 3 Next page

Menu

  • Home
  • Blog
  • About
  • Contact
  • LinkedIn
  • Twitter
  • Instagram

Search

Categories

  • AWS (3)
  • Azure Data Studio (1)
  • Backup/Restore (19)
  • Corruption (8)
  • Execution Plans (35)
  • Failover Clustering (1)
  • Hardware (11)
  • Indexing (27)
  • Joins (2)
  • Locking/Blocking (6)
  • Misc (29)
  • Monitoring (19)
  • MySQL (9)
  • Personal (10)
  • Powershell (12)
  • Python (1)
  • Query Store (3)
  • Query Tuning (47)
  • Security (9)
  • SQL Configuration (51)
  • SQL Server (157)
  • SSMS (109)
  • Statistics (4)
  • T-SQL (121)
  • Uncategorized (1)
  • Updates/Upgrades (14)
  • Wait Stats (4)
  • Workbench (4)

Top Posts

  • Multiple Counts in One Query
  • Inserting and Exporting MySQL Values with PowerShell
  • What is the SQL CEIP Service?
  • Is Dropping a Temp Table in a Stored Procedure Beneficial?
  • In-Place vs. Side-by-Side Upgrades
  • T-SQL Tuesday #160: Microsoft OpenAI Wishlist
  • Missing SQL Failover Cluster Dependency
  • Finding All Database Sizes on a SQL Server
  • XML Compression in SQL Server 2022
  • Querying XML Data in SQL Server
Create a website or blog at WordPress.com
Chad Callihan
Create a website or blog at WordPress.com
  • Follow Following
    • Chad Callihan
    • Already have a WordPress.com account? Log in now.
    • Chad Callihan
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...