Alex questions

Alex answers

• How to test performance of the stored procedure in SQL Server Management Studio
• Is there a way to manually set @@ROWCOUNT?
• Sybase inserts a single space in place of the empty string ''
• SSMS: Pipe Delimited output
• Alternative to sys.columns.max_length
• Recursively retrieve LAG() value of previous record
• ScriptingOptions sql smo does not support scripting data
• Data mismatch when querying with different indexes