Andrey Gurinov questions

Andrey Gurinov answers

• Mysql union from multiple database tables
• In sql is there another way to clear temp db and its log other than restarting the service?
• Using sysschedules like table for events SQL Server
• Permissions required to run 'ALTER DATABASE SET SINGLE_USER' statement on SQL Server 2008
• How do you handle NULLs in a DATEDIFF comparison?
• Calculate Percentile Rank using NTILE?
• SQL Query Concatenate two columns during Inner JOIN
• Comment threading with score factoring
• MySQL select before after row
• Update ANSI_NULLS option in an existing table