How do you display NULL values at the end of a resultset? - 21 Oct 2006

How can I determine the maximum value for each data? And which option provides the best performance? - 21 Oct 2006

How do you mimic Access’ Ignore Null index behavior in SQL Server? - 21 Oct 2006

Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server? - 21 Oct 2006

How do you get rid of users that are already in the database on the backup server when a restore starts? - 21 Oct 2006

Should we automatically reboot our SQL Servers on a weekly basis? - 21 Oct 2006

Why do I get an unordered resultset, although my table has a clustered index? - 21 Oct 2006

Can I downgrade my SQL Server databases to an earlier version? - 21 Oct 2006

How do you create trigger on system tables? - 21 Oct 2006

How do I find the most frequently occurring value for all data in a table? How do I find that value per group? - 21 Oct 2006