sepupic questions

sepupic answers

• 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
• SQL Server name using port number
• The transaction log for database 'test' is full due to 'LOG_BACKUP'. and free space issue with C Drive
• What is the meaning/use of "Owned Schemas"?
• The parameter PASSWORD cannot be provided for users that cannot authenticate in a database
• Checking variable for NULL kills performance
• Drop or not drop temporary tables in stored procedures