Tag: audit

Pro Members SQL Server Standard Members

Some tips to use System Monitor with SQL Server 2014

by

Some tips to use System Monitor with SQL Server 2014 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2014. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. Ensure that SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Some tips to use System Monitor with SQL Server 2014

by

Some tips to use System Monitor with SQL Server 2014 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2014. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. Ensure that SQL […]

Continue Reading →
Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2014

by

Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →