This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.
SQL SERVER – Difference Between DBMS and RDBMS
What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
SQL SERVER – Is Cursor Database Object or Datatype?
Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – Popular Articles of SQLAuthority Blog
Readers often ask about the most popular articles on my blog. Two stand out: SQL Server coding standards and guidelines, and interview questions and answers.