Does anyone know how to check Trigger performance and an execution plan
using Query Analyzer?
I only know how to check Select statements.
Thanks a bunch
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
> Does anyone know how to check Trigger performance and an execution plan
> using Query Analyzer?
> I only know how to check Select statements.
> Thanks a bunch
First a short intro:
Simplified I have a table with 2 dates (see below) where the second
(dateTwo) can't exist without the existence of the first (dateOne). I guess
it would be best to solve this with a constraint, as it is within the same
table, but I have tried for hours, but it just won't work.. please help
create table Date(
DateId int IDENTITY primary key,
dateOne datetime null,
dateTwo datetime null,)