Convert a table to list with ordered STRING_AGG, split a list with STRING_SPLIT ordinals, and handle NULLs and empty tokens clearly.
Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?
Compare primary keys and unique key constraints in SQL Server, including NULL rules, foreign keys, and filtered unique indexes.
Interview Question of the Week #009 – Is GO T-SQL Statement?
Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.
Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case
Convert string values to title case with a corrected function, ordered SQL Server aggregation, and clear limits for personal names.
Interview Question of the Week #007 – How to Reindex Every Table of the Database?
Reindex every table selectively with SQL Server catalog checks, quoted identifiers, and a clear choice of rebuild or reorganize.
Interview Question of the Week #006 – Is Shrinking Database Good or Bad?
Decide whether shrinking database good or bad advice fits your case, inspect fragmentation, and use low-priority shrink cautiously.
Interview Question of the Week #005 – List All the Tables with Name Containing Specific String
Find SQL Server tables whose names contain a specific string, handle literal underscores, and include schemas without a date filter.