T-SQL

Home
Development
T-SQL

Well, it was good, but I dunno about amazing.

Seeks, Scans, and Statistics in the Grocery Store

Last Updated July 14, 2019

Building an execution plan is a lot like going shopping. Before I leave the house, I need to think about a few things: How many items do I need? I take a glance at my grocery list to see roughly how many things I’m shopping for. What stores am I going to visit? I can’t…

Sargability: Why %string% Is Slow

Last Updated December 29, 2017

Brent Ozar

T-SQL

People love to search. Google has us addicted to fast, easy search functions. Users expect every application to have a built-in blazing-fast search functionality. To pull that off, developers build search queries that let users enter a string, and we ask SQL Server to find matches. For example, say our users need to find some…

T-SQL

Seeks, Scans, and Statistics in the Grocery Store

Sargability: Why %string% Is Slow

Save your cart?