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...

Just thought I'd try this, I noticed that the description says "The second CTE, named L1, uses the BaseNum CTE to generate a second result set with one thousand rows....

You could do it with global temporary table and drop it after you've finished with it.

declare @sSql as nvarchar(1000)

declare @GuidTableName as nvarchar(50)

set @GuidTableName = NEWID()

set @sSql='set nocount on;;with...

And does this return anything in any of the date columns?

SELECT T.name, I.name, U.*

FROM sys.tables T

INNER JOIN sys.dm_db_index_usage_stats U

ON U.OBJECT_ID = T.OBJECT_ID

INNER JOIN sys.indexes I ON...

What index does the execution plan say it uses when you access it?

If the table...

Nice script, thank you.

Table Value Constructors were introduced in SQL 2008, so this script doesn't work with versions below that. I've rewritten the query inside the function so it will...

.

Ed Wagner (1/31/2016)

Jonathan AC Roberts (1/31/2016)

This is not good practice, I'm not sure it will even work in versions of SQL Server...

CAST(LEFT(OMD, 8) as datetime) + 30 < GETDATE();

This is not good practice, I'm not sure it will even work in versions of SQL Server later than 2005.

You should be...

If it is parameter sniffing causing the problem then you can just alter the stored procedure to copy the parameters passed in into ones created within the SP.

Example:

GO

CREATE PROCEDURE mySPWithParameterSniffing

(

...