Tag Archives: Interview Questions and Answers

SQL Server Memory Usage

Posted on May 22, 2016 by uday arumilli

SQL Server Memory Usage SQL Server Memory Usage Related Interview Questions and Answers Introduction: This post takes you through “how to monitor SQL Server Memory usage”. Most of the clients I worked with had a common question “What is my … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 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

Upgrading SQL Server Questions and Answers

Posted on October 3, 2014 by uday arumilli

Q&A Upgrading SQL Server Questions and Answers         1. Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition? Ans: You can’t change the version of the installed instance as far as I … Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , | 16 Comments