What would you like help with? The DISTINCT has to be processed first as that's what you're selecting the top 100 of.

He's referring to a logon trigger not a DDL trigger.

Have a look here, which also has a handy example of exactly what you're wanting to do - please use caution...

Please note that Resource Governor is an Enterprise Edition feature only and not available on other Editions (with the exception of Developer Edition)

Ok. I think I see what you're after - DDL and expected result would be useful in the future as people can then give you tested code, but something like...

Is this what you're after?

select APP_ID, MAX(APP_DATE) from Test

group by APP_ID

If it's very slow compared to other applications and quick when it doesn't have to establish a connection, then something's up, but 5-10 seconds just for the connection seems very...

I'm confused how leaving SSMS open all day has an impact on the speed a .Net form opens/closes?

Opening connections is (relatively) expensive, but I wouldn't expect if to take 5-10...

Thanks Gail - wasn't aware of that system view!

I'm not aware of a system view that shows the value, so think you'd have to insert the results of the procedure into a temp table to do this. E.g.:

CREATE...

EXEC sp_configure 'max degree of parallelism'

Not necessarily. The optimiser will look at the statistics to try to determine how selective your where clause is - for example, one particular parameter value may restrict the results...

opc.three (4/1/2011)

---

Regarding the emphasized portion of your comment above: your statement is correct with respect to AFTER triggers, however I am not finding this to be true of INSTEAD OF...

Well I'm certainly not surprised that you're always getting errors. It's a very confused mash up of sub queries within selects within subqueries and in several places is not close...

That's certainly valid and a...

I'm wary of them. My experience of hiring DBAs & Database Developers is that it's simply not any kind of yardstick for ability/suitability. I've had brilliant candidates with no certifications...