SQL Tips and Tricks Archives - Page 115 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Basic architecture of Transaction Logs

September 28, 2015

Readers bump into this blog because it tries to simplify some of the most complex topics into a digestible format. I am a strong believer of this and try to bring some of these topics from time-to-time. Even I find some of these topics confusing, if I can understand them…

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

September 27, 2015

Pinal Dave

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

SQL Joins

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…

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…