Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – New Theme of SQLAuthority and Video Courses

May 31, 2013

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

I have been blogging for almost 7 years now. Recently I reached a very important milestone for my blog. I completed over 2500 blog posts as well have been receiving consistently over 2 Million Views every month. It has been a fantastic ride and I am planning to continue contributing…

SQL SERVER – Add Identity Column to Table Based on Order of Another Column

May 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

After reading my earlier article on Identity Column, I received a very interesting question. The reason, I like to call it interesting is though, I have provided answers to him, I believe there should be another better alternative to this problem. Let us see the question first in his own…

SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052

May 29, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…

SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL

May 28, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('S','Q',…

SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods

May 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Here is a very common question which I keep on receiving on my facebook page as well on twitter. “How do I insert the results of the stored procedure in my table?” This question has two fold answers – 1) When the table is already created and 2) When the…

Blogging Best Practices – Checklist for Building Successful Blog – Part 6

May 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Blogging

Abstract of my Pluralsight Course Building a Successful Blog Module – Checklist for Building Successful Blog. [youtube=http://www.youtube.com/watch?v=12p4j4Ht8os] I hope everyone has learned a little or a lot with me through this whole course. Even if you are already a professional blogger, my hope is that everyone could learn something. I love blogging…

SQL SERVER – Weekly Series – Memory Lane – #030

May 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…