Okay I will try creating these indexes and see if it benefits. Since, the query isn't completing in its entirety I have no clue of the optimizer suggesting an...

Thank you so much for all the help...

• This reply was modified 6 years, 2 months ago by Jonathan AC Roberts. Reason: added PS:

You have an OUTER APPLY (aliased c2) in the query but in the WHERE clause of the main query you have

AND D.LiveTable = c2.TableName

So why is it an OUTER APPLY...

Yep, I agree with you Jonathan AC Roberts, but what if the number of columns is dynamic?  With version 1 it has 3, version 2 has 2, version 3...

Not sure that an index will help anything since there is no WHERE clause or ORDER BY.  No matter what index you put on there, it is going to...

The best way to get this answered is to post the actual SQL that is dynamically generated so we can see what the SQL is doing. (Just change exec(@SQL) to...

deleted answer

• This reply was modified 6 years, 2 months ago by Jonathan AC Roberts.

1. Get the count of the number of rows on the table
2. Get the average size of all the columns on the index
3. Multiply the answers from 1. and 2....

Try this:

select i.ItemID 
  from Item i (nolock) 
  left join QueueItemDeactivation qid (nolock) 
         on i.ItemID...

You could create a temporary table, insert all the rows you need into that. Then just select * from the temporary table.

You really need a lot more test data, you can replace later numbers by adding more...

Here is something that could be a start, if you have no other option:

DECLARE @Words TABLE (Words nvarchar(20));
INSERT INTO @Words 
VALUES ('ROAD'),
     ...

The only reason why I got it right was because it has bitten so many people that work in every company that I've ever worked in including me back...

We have a set of SSIS packages for a data warehouse ETL,  all the dtsx packages are in one solution (project) the entire project is checked into source control (currently...

SELECT DISTINCT
       Reg_Text
  FROM dbo.TestTable
 WHERE Reg_Text NOT LIKE '[A-Z][A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9]%'