Tag Archives: DBA

SQL Server Blocking Report

SQL Server Blocking Report This post can help a SQL DBA / Developer to quickly find the SQL Server Blocking Report using T-SQL scripts. There are various ways to get the SQL Server Blocking Report but here we are going … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment

SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2

SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2 SQL Server Database Administrator – Interview Questions This post “SQL DBA – INTERVIEW QUESTIONS ANSWERS – 2”  helps SQL DBA for interview preparation. Q. Can we hot add CPU to sql server? … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , | 49 Comments

SQL DBA – INTERVIEW QUESTIONS WITH ANSWERS – 1

SQL DBA Interview Questions and Answers – 1 SQL Server Database Administrator – Interview Questions Q. What is the maximum limit of SQL Server instances for a standalone computer? (2008 R2) Ans: 50 instances on a stand-alone server for all … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , | 40 Comments