Category Archives: SQL Server DBA

SQL Server Backup and Restore Interview Questions

Posted on June 26, 2013 by uday arumilli

SQL Server Backup and Restore Interview Questions   Here are the list of SQL Server Backup and Restore Interview Questions which are asked in SQL Server DBA interviews. 1. How does the database recovery model impact database backups? Ans: First the … Continue reading →

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

How to Use DBCC CHECKDB in SQL Server

Posted on June 26, 2013 by uday arumilli

How to Use DBCC CHECKDB in SQL Server Use: By far the most widely used command to check the status of your database is DBCC CHECKDB. This statement checks the allocation and structural integrity of all data and index pages … Continue reading →

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

SQL Server Architecture Questions and Answers

Posted on June 25, 2013 by uday arumilli

SQL Server Architecture Questions and Answers   Here are the list of Sql Server Architecture Questions and Answers which are asked in SQL Server developer / DBA  interviews Q. Can you draw SQL Server architectural diagram with all the components? … Continue reading →

Posted in Database Design, Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 60 Comments