-- Since we have written many queries as of now . But I kinda feel what's the execution logic behind a SQL query as like what statement -- are executed first then next statement and so on. So this ...

The automatic execution of stored programs when a specific event occurs are triggers. triggers are database object binded to a table and are called implicitly. they find their usage while accessing ...

Now thanks to SQL Server 2005/2008, query execution and analyzing is too very much easy. We can do this using reporting services but lets take a bit more convenient way to find out how a query is ...