-- Splits a...

If got a stored procedure I use for searching for a string in a database:
IF NOT EXISTS(SELECT 1
      FROM INFORMATION_SCHEMA.ROUTINES
     WHERE ROUTINE_NAME = 'INFSearchAllTables'
      ...

Interestingly there comes a point where the original query using ROW_NUMBER() becomes the fastest. This is when there are not many QueuedAt values for ObjectType/ObjectId combinations. In my test above...

With these type of query you can sometimes get a lot of success from breaking it up into several queries inserting the data into temporary tables, adding indexes to the...

I've had a lot of success rewriting these type of queries (where it's selecting ROWNUMBER = 1) as a cte with a select distinct followed by another nested query with...

If you use a temporary table you should get better performance:
IF OBJECT_ID('tempdb..#t','U') IS NOT NULL
  DROP TABLE #t
CREATE TABLE #t (nId INTEGER IDENTITY, nVal...

This problem has a massive search space. SQL server won't be the fastest solution. Instead of using a table variable you should use a temporary table. It can be done...

Another point of optimization would be rewriting the scalar Function dbo.fn_SumRangeOfNumbers() so instead of summing integers from a Tally table the function should use the formula for the sum of...