Category: FAQ
How do I find the most frequently occurring value for all data in a table? How do I find that value per group?
How can I determine the maximum value for each data? And which option provides the best performance?
How do you create trigger on system tables?
How do you mimic Access' Ignore Null index behavior in SQL Server?
How do you display NULL values at the end of a resultset?
Why doesn't ISNUMERIC() always produce the results you expect?
How do you determine the Nth row in a SQL Server database?
I am trying to backup my databases from my clustered shared array to a local disk, but I can't see the local disk when I run the Backup Wizard. Why?
How can you use IIf in Transact-SQL?