Information presented in class often contains the core concepts of the course. Yet, students frequently fail to master the skills of classroom notetaking. Our Essential ClassNotes products provide study notes that are specific and concrete. Review questions and classroom discussion topics are also included to make sure students are truly involved in the ideas and information being presented. CONTENT UPDATES 2ABOUT THIS BOOK 2SERVER MANAGEMENT AND ADMINISTRATION 3OVERVIEW 3SERVER LEVEL ROLES 4LOGINS AND CREDENTIALS 7MANAGEMENT STUDIO AND OTHER CONFIGURATION TOOLS 11THE DATABASE ENGINE 17TRANSACTION MODES 19LOCKS, LATCHES AND TRANSACTION ISOLATION LEVELS 21CHAPTER REVIEW QUESTIONS 24DATABASE DESIGN, MANAGEMENT AND ADMINISTRATION 26LOGICAL & PHYSICAL DESIGN 26PERFORMANCE TUNING 29THE SYSTEM DATABASES 31FILES AND FILEGROUPS 35SINGLE USER MODE 38TEMPORARY TABLES AND TABLE VARIABLES 39RESIZING A DATABASE 41MOVING DATABASES 42DETACH AND ATTACH 43CONTAINED DATABASES AND CONTAINED USERS 45BACKUP AND RECOVERY MODELS 47T-SQL STATEMENTS 52SELECT AND THE POSSIBLE OPTIONS 54COMPUTE AND THE POSSIBLE OPTIONS 56FOR AND THE POSSIBLE OPTIONS 58GROUP BY, HAVING AND THE POSSIBLE OPTIONS 59ORDER BY AND THE POSSIBLE OPTIONS 60CHAPTER REVIEW QUESTIONS 61