SQLMenace questions

SQLMenace answers

• Optional parameters in SQL stored procedure
• Result of T-SQL Cursor changes at runtime
• Can SQL Server 2008 use a variable in a WHERE IN clause
• Why does ROW_NUMBER OVER (ORDER BY column) return a different result order than just ORDER BY column?
• How can I tell if a SQL Server database is being backed up
• Push all rows into single row and column
• Is there a legitimate reason for using so many varchar fields? (MS SQL DB)
• Searching geocoded information by distance
• SQL Server trigger an asynchronous update from trigger?
• MS SQL Stored Procedure Problem