SQL Stored Procedure « SQL Server Journey with SQL Authority

Archive for the ‘SQL Stored Procedure’ Category

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

Posted in CodeProject, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology on December 9, 2011 | 8 Comments »

Madhivanan is SQL Server MVP and very talented SQL expert. Here is one of the nugget he shared on Just Learned. He shared a tip where there were two interesting point to learn. Do not use keywords as an object name [read DHall's excellent comment below] He has given excellent example how GO can be [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology, tagged Powershell on November 27, 2011 | 5 Comments »

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 powershell script. Run the same [...]

Read Full Post »

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology on November 26, 2011 | 1 Comment »

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 way he can list directory [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Function, SQL Puzzle, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology on June 4, 2011 | 22 Comments »

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 [...]

Read Full Post »

SQL SERVER – Denali – Executing Stored Procedure with Result Sets

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on April 28, 2011 | 12 Comments »

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 coming up with a very [...]

Read Full Post »

Older Posts »