SQL Server Archives - Page 145 of 393 - 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…

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…