Interview Questions and Answers Part 5 covers renaming a database with sp_renamedb, sp_configure versus SET commands, and the types of replication.
SQL Server Interview Questions and Answers Part 3
Interview Questions and Answers Part 3 opens with NOLOCK: how the hint skips read locks, why that means dirty reads, and what it does for concurrency.
SQL Server Interview Questions and Answers Part 2
Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.
SQL Server Interview Questions and Answers Part 1
Interview Questions and Answers Part 1 starts with the basics: what an RDBMS is and what normalization means. The updated set now lives at a new location.
SQL SERVER – FIX : Error 15023: User already exists in current database.
Error 15023: User already exists in current database. I fix it with sp_change_users_login, using Report, Auto_Fix or Update_One to link the user to a login.
SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables
ReIndexing Database tables with DBCC DBREINDEX and sp_MSforeachtable, then sp_updatestats to refresh statistics. Two scripts, including the one I prefer.
SQL SERVER – Simple Example of Cursor
The simple example of cursor I have used for years: declare it, open it, fetch each Account_ID in a WHILE loop, then close and deallocate the cursor.