Tag Archives: 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. Does TRUNCATE is a DDL or DML and … Continue reading

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

SQL DBA INTERVIEW QUESTIONS WITH ANSWERS – 1

SQL DBA Interview Questions with Answers – 1 SQL DBA Interview Questions with Answers Q. What are the common issues a SQL DBA should deal with as a part of DBA daily job? Ans: Backup Failure Restore Failure Log Full Issues … Continue reading

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

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:   “Incorrect PFS free space information for page (1:233791) in object ID 367392428, index ID 1, partition ID 72057594180730880, alloc unit ID 72057594222018560 (type LOB data). … Continue reading

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