SQL Server Archives - Page 9 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Understanding SQL Server Setup Support Rules for Cluster Nodes

November 10, 2015

SQL Server clustering is one of the oldest and most used techniques when it comes to developing a highly available configuration. Though this has been used by many for years, there are nuances that comes up once in a while if you are a junior DBA that you would like…

SQL SERVER – Save and Send Execution Plan Via Email

November 9, 2015

Pinal Dave

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

SQL Server Management Studio

Here is an interesting question, I received the other day. Hi Pinal, I have a very big graphical execution plan and I want to send it to my friend. My first thought was to send him query to execute on his own machine, but he does not have the same…

Interview Question of the Week #044 – What is the difference of performance between SELECT and SET?

November 8, 2015

Pinal Dave

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

SQL Scripts

Question: What is the difference of performance between SELECT and SET? Answer: SELECT : Designed to return data. SET : Designed to assign values to local variables. While testing the performance of the following two scripts in query analyzer, interesting results are discovered. SET @foo1 = 1; SET @foo2 =…

SQL SERVER – How to Suppress SQL Server messages in Application Event Log

November 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Error messages are a great source of help when it comes to troubleshooting. What can I say, this is maybe be the most repeated phrase from me in this blog about error messages. The messages have grown over ages and got better with the SQL Server dev team putting in…

SQL SERVER – How to Change SQL Server Product Key or License Key?

November 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I try to refrain from talking about licensing related topics because they seem to be complicated and have tons of permutations and combinations. Having said that, in the recent past, I was baffled to see this query land to my Inbox which was interesting and needed some attention from me.…

SQL SERVER – How to take InMemory – OLTP FileGroup Offline?

November 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Error Messages

InMemory topics are always interesting and a great learning experience. When I wrote the other post, it was more about how InMemory tables are loaded into memory even if they are not queried. The basics, here is to bring the data for In Memory Tables ahead to memory irrespective of…

SQL SERVER – Basics ColumnStore FAQ – Part II

November 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

I wrote the first part of FAQ in here. This is not a typical blog post but more of a process oriented topic when working with ColumnStore Indexes. With the advancements done in SQL Server 2016, I know that this is going to be even more critical to understand some…