Browse by Tags

Performace overhead and resolution when using CLR vs TSQL

Published 31 July 7 3:42 AM | SSQA.net

Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds...

Filed under: sql server, performance, memory, server, clr, tsql, managed code

How do I view the definition of a server-level trigger?

Published 16 July 7 7:43 AM | SSQA.net

SELECT definition FROM sys.server_sql_modules; GO Books online documented the usage of triggers for the business needs: Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs...

Filed under: sql server, server, trigger, tsql