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

SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server

November 27, 2011

Powershell, SQL Scripts, SQL Stored Procedure

Earlier I have written this article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server. I recently received excellent comment by MVP Ravikanth. He demonstrated that how the same can be done using Powershell. It is very sweet and quick solution. Here is the…

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

November 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any…

SQL SERVER – Question to You – When to use Function and When to use Stored Procedure

June 4, 2011

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Server, SQL Stored Procedure

This week has been very interesting week. I have asked few questions to users and have received remarkable participation on the subject.
Q1) SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
Q2) SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
Keeping the same spirit up, I am asking the third question over here.
Q3) When to use User Defined Function and when to use Stored Procedure in your development?

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

April 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Here is a normal conversation I heard when I saw that the function (UDF) was used instead of the procedure (SP). Q: Why are you using User Defined Function instead of Stored Procedure? A: I cannot SELECT from SP, but I can from UDF. SQL Server’s next version ‘Denali’ is…

SQL SERVER – System Stored Procedure sys.sp_tables

October 17, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL System Table

I have seen people running the following script quite often, to know the list of the tables from the database: SELECT * FROM sys.tables GO The script above provides various information from create date to file stream, and many other important information. If you need all those information, that script…

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

October 10, 2010

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure

I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor.

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only

September 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Stored Procedure, SQL String

I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He…