Tag Archives: sql SERVER DBA

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 , , , , , , , | 46 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 , , , , , , , | 36 Comments

SQL Server Production Issues

SQL Server Production Issues Prod Problems and Solutions:      Below are the common problems from production environment.  SQL Server Log full alert  SQL Server Blocking Alert Low Disk Space/Disk Full       Now here are the solutions for these issues…………….    SQL … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 2 Comments