Category Archives: SQL Development

SQL Server Performance Tuning Interview Questions – Part 2 – Indexes

Posted on December 17, 2014 by uday arumilli

sql server performance tuning interview questions Performance Tuning – SQL Server Part -2 – Indexes Q. What are the primary differences between an index reorganization and an index rebuild? Ans: Reorganization is an “online” operation by default; a rebuild is … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , | 29 Comments

SQL Server Performance Tuning Interview Questions – Part 1

Posted on December 17, 2014 by uday arumilli

Sql Server Performance Tuning Interview Questions Performance Tuning – SQL Server  Part – 1 Q. What are the bottlenecks that effects the performance of a Database / Application Ans: The top performance bottlenecks for OLTP applications are outlined as: Database … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 47 Comments

MSSQL Concurrency Control and Locking – MSSQL Interview questions with answers

Posted on October 29, 2014 by uday arumilli

Concurrency Control And Locking SQL Server Concurrency Control Interview Questions Concurrency and Locking – Interview Questions with answers 1. What are the concurrent problems occur in accessing database? Ans: Tr – Transaction R – Resource Uncommitted dependency/dirty reads: Tr1 Updates Data R1 … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , | 1 Comment