SQL Interview Questions and Answers Archives - Page 45 of 67

Interview Question of the Week #005 – List All the Tables with Name Containing Specific String

February 1, 2015

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

The other day, I received an email from a blog reader. When he appeared for an interview, he was asked to retrieve all the tables where the name of the table contained the words ‘tbls_’. This was a very interesting scenario. As the organization had earlier adopted a specific naming…

Interview Question of the Week #004 – List All Columns and Their Data Type for a View

January 25, 2015

Pinal Dave

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

SQL Scripts

Earlier this week I wrote a blog about finding stored procedure parameters and their data types. After that blog I received few emails from my blog readers asking for similar script for a view. I asked them what did they like about the script and they said that it gives us…

Interview Question of the Week #003 – How to Write Script for Database Cursor?

January 18, 2015

Pinal Dave

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

Just another day I heard a senior DBA discussing advantages and disadvantages of the cursor. Well, personally I am a firm believer of the set based operations. However, there are few places where cursors are the only solutions. It is quite possible that different experts have different opinion about cursor;…

Interview Question of the Week #002 – Script to Find Byte Size of a Row for All the Tables in Database

January 11, 2015

Pinal Dave

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

In recent times I was part of the interview panel where I was stunned to see that following question was asked to interviewee. I personally believed that this question is no longer relevant as we are in the age where database are capable to handle large amount of data and the…

Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name

January 4, 2015

Pinal Dave

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

SQL Constraint and Keys

Two years ago I wrote a book SQL Server Interview Questions and Answers with my very close friend Vinod Kumar. It is a very popular book of mine and has sold many thousands of copies so far. Every single day I still get quite a many different interview questions in…

SQL SERVER – How to Catch Errors While Inserting Values in Table

October 5, 2014

Pinal Dave

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

SQL Error Messages

Question: “I often get errors when I insert values into a table, I want to gracefully catch them, how do I do that.” Answer: Very simple. Just use TRY… CATCH. Here is the simple example of TRY…CATCH I have blogged earlier when it was introduced. Here is the example, I…

SQL SERVER – Basics of Delayed Durability in SQL Server 2014

September 6, 2014

Pinal Dave

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

SQL Server 2014 has introduced many new features and one of performance is Delayed Transaction Durability. This concept is indeed very interesting. To explain this feature in detail, we will require to understand what is Full Transaction Durability. The current default of SQL Server is Full Transaction Durability. A common…