sepupic questions

sepupic answers

• Explicitly lock and unlock a table using ODBC
• TSQL CTE's (common table expression) bug
• Old name of the procedure in sp_helptext
• Restoring Daily Differential Backup - No Files Are Ready To Rollforward Issue
• "Invalid column name" error when using data migration scripts
• Unable to restore SQL Server bak file from S3, says file too large
• Read Committed vs Read Uncommited if both transaction do not rollback
• Why is the performance of table value function better than select direct statement?
• What permissions to I need to use User Defined Table Types
• SQL Server Memory Optimized Table - poor performance compared to temporary table