Pinal Dave - SQL Server Performance Tuning Expert

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

September 27, 2015

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

It is very common of interviewers to ask questions which are a bit off and sometimes not used in daily life. Here is such question I heard the other dya. Question: What is Left Semi Join Showplan Operator? Answer: There are few interesting kinds of joint operations exists when execution…

SQL SERVER – How to Restore Corrupted Model Database from Backup?

September 26, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Another email from one of my blog reader, which made me think about the incorrect information which is available on the internet. Hi Pinal, I have corruption in model database and due to that SQL Service is not able to start. Here are the messages in SQL ERRORLOG 2015-09-23 21:45:07.00…

SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”

September 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I always try to keep myself up-to-date with latest release of SQL Server. As a part of that I wanted to upgrade my SQL Server 2016 CTP2.2 to CTP2.3 version. While doing in-place upgrade I was blocked with few error and I was not able to proceed. Here is the…

SQL SERVER – Finding If Date is LastDay of the Month

September 24, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

As I said many times before SQL Server does not stop amazing me continuously. It does not matter how many questions and issues I have come across so far there are always new things to learn. Here is the question which I was asked – How do we know if…

SQL SERVER – Scope of ERROR_MESSAGE

September 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

SQL Server supports Error handling efficiency. You can do this with the help of TRY and CATCH blocks. If there is an error you can get the exact error message using the system function ERROR_MESSAGE(). I will demonstrate it using the following code BEGIN TRY SELECT 1+'SQL' AS RESULT END…

SQL SERVER – Security Considerations for Contained Databases

September 22, 2015

Pinal Dave

SQL

SQL Server, SQL Server Security

I have written a number of blogs around contained databases in the past which you can search. In today’s blog we will talk about security considerations when working with contained databases. With contained authentication, the database can contain authentication information for the database users. This makes it considerably easier to move databases between servers. Some of the other blogs for reference are:

Interview Question of the Week #037 – What are the Properties of Relational Tables?

September 20, 2015

Pinal Dave

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

The other day in the interview, I heard this question and it sent me back to my college days as I used to hear similar questions from my professors. Here is the same question again and its answer. Question: What are the properties of the relational tables? Answers: Relational tables have…