All Articles - SQL Authority with Pinal Dave

SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function

June 16, 2012

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

Earlier this week I asked a question where I asked how to Swap Values of the column without using CASE Statement. Read here: A Puzzle – Swap Value of Column Without Case Statement,there were more than 50 solutions proposed in the comment. There were many creative solutions. I have mentioned my personal…

SQL SERVER – Free eBook Download – EPUB, MOBI, PDF Format

June 15, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation

Microsoft has released recently free eBooks on various Microsoft Technology. The best part is that all these books are available in ePub, Mobi and PDF. You can download them to your local machine or eBook reader and read them. This is a great start as many important subjects are now…

SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement

June 14, 2012

Pinal Dave

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

SQL Function, SQL Scripts

Earlier this week I asked a question where I asked how to Swap Values of the column without using CASE Statement. Read here: SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement. I have proposed 3 different solutions in the blog posts itself. I had requested the help…

All Articles SQLSERVER_EXCEPT_ExecPlan_Big-600x400

SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan

June 13, 2012

Pinal Dave

SQL Performance

Execution Plan, SQL Server

Traveling can be most interesting or most exhausting experience. However, traveling is always the most enlightening experience one can have. While going to long journey one has to prepare a lot of things. Pack necessary travel gears, clothes and medicines. However, the most essential part of travel is the journey to the destination. There are many variations one prefer but the ultimate goal is to have a delightful experience during the journey. Let us learn about Performance Tuning with SQL Server Execution Plan.

SQL SERVER – A Quick Look at Logging and Ideas around Logging

June 12, 2012

Pinal Dave

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

This blog post is written in response to the T-SQL Tuesday post on Logging. When someone talks about logging, personally I get lots of ideas about it. I have seen logging as a very generic term. Let me ask you this question first before I continue writing about logging. What…

SQL SERVER – Developer Training Resources and Summary Roundup

June 11, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Training

It is always pleasure for any author when other renowned authors in the industry write about you. Earlier I wrote a five part blog series on Developer Training and I have received a phenomenal response to the series. I have received plenty of comments, questions and feedback. I thought it…

SQL SERVER – Finding Size of a Columnstore Index Using DMVs

June 10, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

Columnstore Index is one of my favorite enhancement in SQL Server 2012. A columnstore index stores each column in a separate set of disk pages, rather than storing multiple rows per page as data traditionally has been stored. In case of the row store indexes multiple pages will contain multiple rows of…

SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage

June 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Service Broker, SQL Scripts

I have mentioned several times on this blog that the best part of blogging is the questions I receive from readers. They are often very interesting. The questions from readers give me a good idea what other readers might be thinking as well. After reading my earlier article Simple Example…

SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement

June 8, 2012

Pinal Dave

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

For the last few weeks, I have been doing Friday Puzzles and I am really loving it. Yesterday I received a very interesting question by Navneet Chaurasia on Facebook Page. He was asked this question in one of the interview questions for job. Please read the original thread for a complete…

SQL SERVER – Load Generator – Free Tool

June 7, 2012

Pinal Dave

SQLAuthority News

SQL Server, SQL Utility

One of the most common questions I receive is if there any tool available to generate load on SQL Server. Absolutely there is a fabulous free tool available to generate load on SQL Server.