Well, that's a shame. I'm pretty much restricted to operating this way for this need - but it matches up with the fact that I could find no prebuilt...

This was actually a hypothetical - I'm trying to get it right before I get that far down the road. The solution I eventually decided on was:

SELECT

t.*

FROM

dbo.[top] t

WHERE

EXISTS (SELECT...

CREATE TABLE [dbo].[top](

[id] [int] NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[child1](

[number] [int] NOT NULL,

[t_id] [int] NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[child2](

[number] [int] NOT NULL,

[t_id] [int] NOT NULL

) ON [PRIMARY]

insert [top] (id)

select...

Lowell (6/24/2011)

---

can you create a job today, pull from that view, and log the changes for 6 months or something?

at least you'd be able to answer better with some...

Lowell (6/24/2011)

---

it has the last tiem an index had a SEEK or SCAN against it, which occurs even on selects..and of course on insert/update/delete to find the records as well....so...

Thanks, I didn't know that, but sounds like that doesn't help my...

Sadly,...

Jayanth_Kurup (6/24/2011)

---

First things first modify model database to include a script to log table creations as well as modifications. The logic could be trigger based or job based doesn't really...

Lowell, unfortunately, I believe you are correct. I've already looked that blog entry while looking for answers, and this method is accurate only since the SQL Server was last...

John Mitchell-245523 (6/8/2010)

---

James

I don't understand what you mean by "I usually get all records in the index" and "that fixed 2 of the 3 records that were table scanning". ...

Ninja's_RGR'us (6/8/2010)

---

Well just to be sure.

What I understand is that 99.9% of the queries, the plan is an index seek. However with a couple cases you get...

Ninja's_RGR'us (6/8/2010)

---

How much rows (in % of the total rows in the table) are returned by those 1-2 cases?

Are those rows returning more data than the other correct cases?

How are...