April 13, 2007 - SQL Authority with Pinal Dave

SQL SERVER – Stored Procedures Advantages and Best Advantage

April 13, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

There are many advantages of Stored Procedures. I was once asked what do I think is the most important feature of Stored Procedure? I have to pick only ONE. It is tough question. I answered : Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached…

SQL SERVER – Script to Find SQL Server on Network

April 13, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Utility

I manage lots of SQL Servers. Many times I forget how many server I have and what are their names. New servers are added frequently and old servers are replaced with powerful servers. I run following script to check if server is properly set up and announcing itself. This script…

SQL SERVER – 2005 – Disable Triggers – Drop Triggers

April 13, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security, SQL Trigger

There are two ways to prevent trigger from firing. 1) Drop Trigger Example: DROP TRIGGER TriggerName GO 2) Disable Trigger DML trigger can be disabled two ways. Using ALETER TABLE statement or use DISABLE TRIGGER. I prefer DISABLE TRIGGER statement. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name […