Tag Archives: Administration

Top 10 SQL Server Architecture Interview Questions

Top 10 SQL Server Architecture Interview Questions SQL THE ONE There are total 46 questions are answered under SQL Server Architecture category in the book “SQL THE ONE”. In this chapter we’ll find interview questions and answers on SQL Server … Continue reading

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

How to Use DBCC CHECKDB in SQL Server

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

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”

“Ctrl + R” is not working in SQL Server 2012: “Ctrl+R was pressed .Waiting for second key of chord..”   Keyboard short cut “Ctrl+R” is used to Show or hide the query results pane in SQL Server 2005/2008/R2 whereas in … Continue reading

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , | 3 Comments