All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

April 28, 2011

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 – Introduction to SQL Azure – Creating Database and Connecting Database

April 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive. Here are the quick steps I have done after I logged into the portal here: Purchased subscription Created Server Created Database Connect using Database Honestly…

SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course

April 26, 2011

Pinal Dave

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

Best Practices, SQL Scripts, SQL Training

The Moral of Story You can watch the most popular SQL Server – TSQL course on Pluralsight On-Demand for FREE for the next 48 hours. It starts NOW! The Story Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology…

SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone

April 25, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database

It has been a tradition in this blog to write a “milestone blog post” for every 100th post. I am always looking forward to this because I am given a chance to do only three times a year. This year 2011 has been very nice to me so far- lots…

SQL SERVER – How to ALTER CONSTRAINT

April 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

After reading my earlier blog post SQL SERVER – Prevent Constraint to Allow NULL. I recently received question from user regarding how to alter the constraint. No. We cannot alter the constraint, only thing we can do is drop and recreate it. Here is the CREATE and DROP script. CREATE…

SQL SERVER – How to Use Decode in SQL Server?

April 23, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

One of the reader of the blog has sent me question regarding how to use DECODE function in SQL Server.

SQL SERVER – Potential Bottlenecks for Performance

April 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In recent GIDS presentation, I was asked can I name potential bottlenecks for performance. I was taken back to my collage life with this question. I remember that I have memorized following names as potential bottlenecks. CPU RAM Hard Disk Network Application Code Today when I look back at this,…

SQL SERVER – Prevent Constraint to Allow NULL

April 21, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

With naked eyes, we often spot the evident problems but the specific details are missed many a time. Something similar happened recently. One of the blog readers sent me an email asking about a bug in how CHECK CONSTRAINT works. He suggested that check constraint accepts NULL even though the…

SQLAuthority News – Last 5 Days to WIN Windows Phone 7 – 140 Words to Win

April 20, 2011

Pinal Dave

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

You can win Windows 7 Phone by writing only 140 Characters. You need to leave a comment over here: SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL over here. There are so far around 150 comments and I believe that chances of…

SQLAuthority News – Sudden Death of SSD on my Laptop – A Warning for SSD Users

April 19, 2011

Pinal Dave

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

The solid state drive on my personal laptop just died. Here’s the story. I have a DELL XPS laptop which is now 2.5 years old. The laptop had demonstrated no issues. About 6 months ago, I decided to upgrade the hard drive to solid state drive. There was a lot…