Seeks Aren’t Always Better Than Scans
So I was doing a little performance tuning of a query for a company recently and we were getting hammered on the IO for the query. The query was in a stored procedure which wasn’t all that complex (ignore the crap code for now). ALTER PROCEDURE [dbo].[iu] ( @p uniqueidentifier, @as int, @t datetime ) […]