Oh I see what you are saying..thanks Gsquared

I think I can get a pretty good list of the kinda stuff they query the most, but...

It does have a timestamp, I will try that.

THANKS MATT

Is there some way I can force/require them to use a date (or date range)?

Thanks Grant,

I'll experiment with both those options and look into using 08.

Thanks for answering Matt,

Yes this table is kind of a troubleshooting table. So, there are techs that need to see real time info.

I was trying to think of a...

Sorry GSquared.

Thanks SSCarpal Tunnel, I will try your suggestions!

Great advise

Thanks Michelle

Just so I'm clear on this, you all think that SQL should be able to handle 300 unique inserts per second and still be able to handle queries run against...

Thanks Michelle, will do.

Yeah..I know what u mean about adding a second table.

I guess I was thinking that the (#1) insert table would have no indexes or pkeys, and the (#2) searchable...

I haven't seen it yet, But I'm told it's diagnostic data. Users, transactions, searches that sorta thing. The table only has about 10 columns tho, fwiw.

Yes, they are querying...

You guys are right.

I tried it and it was no real benefit.

Thanks very much for your time, and knowledge.

Thanks Noel.

I was really just going to give it a shot and see what happens.

Here's the proc, sorry it's a long one..

Can anyone tell me where the hint would go?

ALTER...

Thanks everyone, very informative.

I meant to write back sooner, but have been busy with your suggestions.

Thanks again, you all rock.