Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.
Interview Question of the Week #017 – Performance Comparison of Union vs Union All
Compare UNION vs UNION ALL with duplicate examples, compatible types, actual plans, and the extra work required for distinct rows.
Interview Question of the Week #016 – How to Take Database Offline
Take a database offline with the right waiting policy, compare detach and SINGLE_USER, and verify SQL Server state before and after.
Interview Question of the Week #015 – How to Move TempDB to Different Drive
Move tempdb files using sys.master_files and ALTER DATABASE, prepare Windows folders, restart SQL Server, and diagnose a full log first.
Interview Question of the Week #014 – How to DELETE Duplicate Rows
Delete duplicate rows with a ROW_NUMBER CTE, preview the duplicate groups, choose a survivor, and prevent recurrence with uniqueness.
Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure
Learn how to create stored procedure code with parameters and NOCOUNT, then review security, plan reuse, and parameter-sensitive plans.
Interview Question of the Week #012 – Steps to Restore Bak File to Database
Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.