We are not perfect and we are very much open to correct our mistakes. This page contains all the known errata of SQL Server Interview Questions and Answers Book.
Page No 22 – Stored Procedures are SQL commands created previously…
Correction: A stored procedure (SP) is a named group of SQL statements that have been created together and stored in the server database.
Page No 24 – SQL Server contains special triggers like login triggers and DDL triggers.
Correction: SQL Server contains special triggers like logon triggers and DDL triggers.
Page No 71 -When is the use of the UPDATE_STATISTICS command appropriate?
Correction: When is the use of the UPDATE STATISTICS command appropriate?
Page No 76 – What is the difference between a local temporary table and a global temporary table?
Correction in Answer: A global temporary table remains in the database as long as connection exists. When that connection is closed, the global temporary table disappears. Unlike local temporary table global temporary table can be accessed while it exists from another connection.
Page No. 168 – Before you can create a log backup you must create a full backup such as a database backup
Correction in Answer: Before you can create the first log backup, you must create a full database backup.
We are continuously improving the book and making it error free. Once we notice errata, the next set of books printed are free from the same.
Please send your erratas, suggestions and feedback to books “at” SQLAuthority.com
[...] a limit of 256 tables per query, and that’s wrong. I’d recommend keeping the book’s online errata [...]