Q1. How to truncate a SQL Server log file while the database stays online ?

Q2. How to copy data and structure to a new table (e.g. backup a table)

Q3. Using bulk insert

Q4. Logging SQL Syntax errors in SQL Server

Q5. Using TOP twice to psuedo paginate

Q6. Using Group By to get row count based on an aggregate.

Q7. Using Group By and Having to find duplicates

Q8. Doing an Update from one table to another.

Q9. Copy data from one table to another (structure already in place)

Q10. OpenQuery Notes

Q11. SQL Server functions - Scalar versus Table values

Q12. Doing a Group By along with a join to get info from another table

Q13. Cleanup orphaned data using NOT EXISTS

Q14. Getting the top N rows for each group.

Q15. Oracle views and performance

Q16. Useful blocks for YL / Field Development

Q17. Copy a PPL from one MU to another (to be done after copying donor contacts)

Q18. Mass inserts for Camp Trip app