T-SQL Archives - Page 3 of 3 - Brent Ozar Unlimited®

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

Seeks, Scans, and Statistics in the Grocery Store

May 10, 2011

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

June 9, 2010

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…