OK... I am getting. (sorry) Very helpful. One more question. If I change your code to make there by multiple types by animal first. I...

Thanks. I'm just confused about this part:

with DogCat(Animal, Amount) as

(

select 'Dog', 1 union all

select 'Dog', 2 union all

select 'Dog', 3 union all

select 'Cat', 10 union all

select 'Cat', 20

)

I don't...

ok - this looks cool!!! Especially this part --- http://sqlfool.com/2009/03/find-missing-indexes/

It isn't even anything I need to install. It is just code that "informs" me...

Thank you

Ever heard of Performance Dashboard?

ok, your original post changed??

In this instance I don't have a choice with the table design.

Even with the if statement?

IF ((ISNUMERIC(@fiscalyear) = 1) AND @fiscalyear >=20012002 AND @fiscalyear <=20112012)

How would it be possible?

Thank you 🙂

I got it. Thank you

Do you see any problems with this?

ALTER PROCEDURE [dbo].[SP_MOR_TestingWorking2](

@fiscalyear char(8)

)

AS

BEGIN

DECLARE @sql NVARCHAR(100)

IF ((ISNUMERIC(@fiscalyear) = 1) AND @fiscalyear >=20012002 AND @fiscalyear <=20112012)

BEGIN

SET

@sql = 'SELECT * FROM tblMOR_LU_AdCpGp'...

Good link. Thank you.

What does it mean to:

Recompile

This is only an option on SQL 2008. On 2008, if the query is specified with the OPTION (RECOMPILE) hint, then the...

Was this problem solved? I found this too-------

http://support.microsoft.com/kb/982854

If possible, would you post how you made out.

Thank you!

OK - I've gotten a lot of advice on this. Thank you so much. I think... the problem is solved. What was done -

1) Indexes rebuilt...

vince_sql (9/28/2011)

---

mjbkm (9/28/2011)

---

OK - what...

GilaMonster (9/28/2011)

---

mjbkm (9/28/2011)

---

GilaMonster (9/28/2011)

---

From a query window (connected to that database)

EXEC sp_updatestats

Or, maybe better

UPDATE STATISTICS <table name> WITH FULLSCAN

where <table name> is the name of the table that you did...

bkubicek (9/28/2011)

---

mjbkm (9/28/2011)

---

Also - you said:

"It is also possible the inserts are not actually going to the end of the table, but are being inserted all over the table, then...