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

SQL SERVER – How to Rename a Column Name or Table Name

August 26, 2008

I often get requests from blog reader for T-SQL script to rename database table column name or rename table itself. Here is a video demonstrating the discussion [youtube=http://www.youtube.com/watch?v=5xviNDISwis] The script for renaming any column : sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' The script for renaming any object (table, sp etc) :…

SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log

August 21, 2008

Pinal Dave

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

SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log works and Shrinking of Log works. Question from lauraV Please help me understand. I am taking a…

SQL SERVER – XML – Split a Delimited String – Generate a Delimited String

August 17, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, MVP, SQL Scripts, SQL Server, SQL Stored Procedure, SQL XML

SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL and XML. Let us see how to Split a Delimited String.

SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions

August 14, 2008

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date time in desired format. I suggest every reader of this blog to save this script in your permanent code bookmark and use it when you need it. Let us learn about User Defined Functions.

SQL SERVER – Query to Find Column From All Tables of Database

August 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table

One question came up just a day ago while I was writing SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there…

SQL SERVER – Find Space Used For Any Particular Table

July 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Server, SQL Stored Procedure

We often run out of the space in our drive and that is the number 1 cause of SQL Server engine stop running on various machines. Quite often we wonder how much space if any of the objects takes in the database. It is very simple to find out the space used by any table in the database.

SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column

June 4, 2008

Pinal Dave

SQL Tips and Tricks

CSV, Database, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

I received following question in email : How to create a comma delimited list using SELECT clause from table column?