radar questions

radar answers

• How to shrink a log file without backuping first?
• Find duplicate records in large table on multiple columns the right way
• sql select min, return value from different column in same row with grouping
• using LIKE %% with LEFT JOIN
• Limit a LEFT JOIN Subquery to 1 result
• C: Sorting Big Data; Not in Memory
• Converting 1 record with a start and end date into multiple records for each day
• SQL Server get column not in Group By clause?
• Row and column total in dynamic pivot
• Oracle SQL CASE WHEN ORA-00932: inconsistent datatypes: expected CHAR got NUMBER 00932. 00000 - "inconsistent datatypes: expected %s got %s"