Apply best practices around filegroups with table placement, independent backups, read-only archives, and staged recovery planning.
Interview Question of the Week #031 – How to do Case Sensitive SQL Query Search
Run a case sensitive SQL query search with explicit collations, inspect current settings, and design an index for repeated exact matches.
Interview Question of the Week #030 – Retrieve Last Inserted Identity of Record
Retrieve the last inserted identity of record safely, compare identity functions with a trigger, and capture multi-row values using OUTPUT.
Interview Question of the Week #029 – Difference Between CHARINDEX vs PATINDEX
Compare CHARINDEX vs PATINDEX, test literal and wildcard searches, preserve positions, and use SQL Server 2025 REGEXP_INSTR when needed.
Interview Question of the Week #028 – Few SQL Best Practices
Apply SQL best practices through ten reasoned rules for data meaning, predicates, parameters, indexes, ordering, and workload measurement.
Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Diagnose low disk pressure in tempdb before moving files, inspect transaction and allocation usage, and plan a verified Windows restart.
Interview Question of the Week #026 – 64 Bit Vs 32 Bit Confusion
Resolve 64 bit vs 32 bit questions for SQL Server, separate engine and client architecture, and inspect the actual Windows host.