SQL Interview Questions and Answers Archives - Page 59 of 67

SQL SERVER – TRANSACTION, DML and Schema Locks

June 21, 2010

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

SQL Scripts, SQL Stored Procedure, SQL Transactions

Today we will be going over a simple but interesting concept. Many a time, I have come across the lack of understanding on how the transactions work in SQL Server. Today we will go over a small but interesting observation. One of my clients had recently invited me to help…

SQL SERVER – Interview Questions & Answers Needs Your Help

March 19, 2010

Pinal Dave

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

SQL Documentation, SQL Download

Click here to get free chapters (PDF) in the mailbox About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions…

SQL SERVER – Difference Between Update Lock and Exclusive Lock

February 15, 2010

Pinal Dave

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

SQL Lock

I have often got this question on this blog as well in different SQL Training. What is the difference between Update Lock and Exclusive Lock? When Exclusive Lock is on any processes no other lock can be placed on that row or table. Every other process have to wait till…

SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time

November 8, 2009

Pinal Dave

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

SQL Cache, SQL Scripts, SQL Stored Procedure

During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored…

SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational

August 18, 2009

Pinal Dave

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

SQL Server MVP and my personal friend Jacob Sebastian has published my interview on subject of Beyond Relational on his famous site Beyond Relational. Jacob is quite known for his T-SQL challenges as well. If you have not ever tried one, I suggest you give it a try and you…

SQLAuthority News – Interview with SQL Server MVP Glenn Berry

August 9, 2009

Pinal Dave

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

Database, MVP

Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS. He is also an Adjunct Faculty member at University College – University of Denver, where…

SQL SERVER – What is Interim Table – Simple Definition of Interim Table

June 4, 2009

Pinal Dave

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

SQL Scripts

Sometimes a simple question like “What is interim table?” can initiate a never-ending discussion between developers. I experienced this recently while I was on phone helping my friends working in Los Angeles. In a conference call, one of the developers kept on talking about “first interim table” and “second interim…