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

Q2. Using bulk insert

Q3. Logging SQL Syntax errors in SQL Server

Q4. Using TOP twice to psuedo paginate

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

Q6. Using Group By and Having to find duplicates

Q7. Doing an Update from one table to another.

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

Q9. OpenQuery Notes

Q10. SQL Server functions - Scalar versus Table values

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

Q12. Cleanup orphaned data using NOT EXISTS

Q13. Getting the top N rows for each group.

Q14. Oracle views and performance

Q15. Useful blocks for YL / Field Development

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

Q17. Mass inserts for Camp Trip app

Q18. Copy PPL Events

Q19. Update From

Q20. Oracle 4 part naming (used in update from)

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

Q22. Get list of Contacts who are deleted donors for an area (to mark inactive or delete)

Q23. How to import XML data

Q24. Using the Pivot clause to turn rows into columns