SQL Interview Questions and Answers Archives - Page 46 of 67

SQL SERVER – What is the Difference Between Latches and Locks

March 16, 2014

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

A very common question I often get in the email is “What is the difference between latches and locks?” The answer to this question is not an easy one. Here is a quick answer from the MS white paper. A page in SQL Server is 8KB and can store multiple…

SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running

March 15, 2014

Pinal Dave

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

SQL Server Management Studio, SQL Stored Procedure

Here is one of the very common interview questions I often ask people – Q: What is the default Port SQL Server running on? A: 1433 for TCP/IP and 1434 for USD connection. I always get the correct answer for this question. However, when I ask a follow up question,…

SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip

January 20, 2014

Pinal Dave

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

In one of the recent interview I had asked questions of interviewees – If you are a SQL Server Developer there must be times when you want to validate syntax, but do not want to execute a query. What is the surest way to check that your syntax is valid…

SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055

July 17, 2013

Pinal Dave

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

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Have you ever needed WAIT or DELAY function in SQL Server? Well, I personally have never needed it but I see lots of people asking for the same. It seems the need of the function is when developers are working with asynchronous applications or programs. When they are working with…

SQL SERVER – Maximize Database Performance with DB Optimizer – SQL in Sixty Seconds #054

June 26, 2013

Pinal Dave

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

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Performance tuning is an interesting concept and everybody evaluates it differently. Every developer and DBA have different opinion about how one can do performance tuning. I personally believe performance tuning is a three step process Understanding the Query Identifying the Bottleneck Implementing the Fix While, we are working with large…

SQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053

June 19, 2013

Pinal Dave

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

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier this week, I have done five part blog series on NuoDB and it was very well received by audience. NuoDB is an elastically scalable SQL database that can run on local host, datacenter and cloud-based resources. t is an operational NewSQL database built on a patented emergent architecture with full support for SQL and ACID…

SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052

May 29, 2013

Pinal Dave

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

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…