(Paul White) This article explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.

(Pinal Dave) One of the blog reader sent me the below mail. I always find that using linked server have been of concern and trouble at a number of places. So when the mail landed – well I was not surprised that there was a problem.

(Arthur Olcot) A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts.

(Krishna Kumar) In this article, I’ll first touch on why containers are important, and how they can be a better solution for some software development tasks than using virtual machines. I’ll then explain some of the jargon around Docker. With that out of the way, I’ll give you a step-by-step guide t

(Paul White) This article explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.

(Pinal Dave) One of the blog reader sent me the below mail. I always find that using linked server have been of concern and trouble at a number of places. So when the mail landed – well I was not surprised that there was a problem.

(Manoj Pandey) In my [previous post] I discussed on how to format/convert any Query/Table data to a string in JSON format. JSON in SQL Server was limited to this feature only till the CTP 2 version.

(Greg Larsen) The installation process for SQL Server has changed slightly with the release of SQL Server 2016. You now have a couple of new installation options available when you install SQL Server 2016.

(Ghanesh Prasad) You created a SQL Server Reporting Services report and the requirement is to output to Excel format. As you may know, SQL Server Reporting Services (SSRS) provides functionality to export a SSRS report into Excel, but for long reports the column headers disappear in Excel when you s

(Manoj Pandey) In my [previous post] I discussed on how to format/convert any Query/Table data to a string in JSON format. JSON in SQL Server was limited to this feature only till the CTP 2 version.