SQL Stored Procedure Archives - Page 21 of 30 - SQL Authority with Pinal Dave

SQL SERVER – Find Table in Every Database of SQL Server – Part 3

May 16, 2008

SQL Scripts, SQL Stored Procedure, SQL Utility

Previously I wrote two articles about SQL SERVER – Find Table in Every Database of SQL Server SQL SERVER – Find Table in Every Database of SQL Server – Part 2 I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole…

SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions

May 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure

Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with more organized constraint names, which helps to easily identify the constraint database exist on. Christopher Miller – “When we submit…

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

April 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.…

SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure

March 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL System Table

How many times we all DBA’s might have wonder which stored procedure is executing most in the database? I have wondered it often and I have written following small script which gives me answer to my above questions. I am also retrieving few additional data along with the highest used…

SQLAuthority News – Authors Most Visited Article on Blog

March 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Stored Procedure, SQL Utility

I received many emails regarding SQLAuthority News – 500th Post – An Interesting Journey with SQL Server. One of the email asked interesting question regarding my most visited article on this blog. It was interesting to know that reader wants to know which article I visit the most. Following is…

SQL SERVER – Correct Syntax for Stored Procedure SP

November 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Just a day ago, I received interesting question about correct syntax for Stored Procedure. Many readers of this blog will think that it is very simple question. The reason this is interesting is the question behavior of BEGIN … END statements and GO command in Stored Procedure. Let us first…

SQL SERVER – 2005 – List All Stored Procedure in Database

November 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database. SELECT * FROM sys.procedures; This will ONLY work with SQL Server 2005. Reference : Pinal Dave (https://blog.sqlauthority.com)