Question : I have been monitoring the execution of my stored procedures in my webservers in order to tune them […]
Tag: table-variable
temp tables in tempdb are not cleaned up by the system
Question : My question is similar to the one asked here: SQL Server tempdb rogue temporary tables Since I don’t […]
improving performance – how to pass a table as parameter in sql server 2005?
Question : I have been monitoring the execution of my stored procedures in my webservers in order to tune them […]
Should I use tempdb or memory optimized table variable?
Question : I would like to change some of my stored procs to use memory optimized tables. Before I do […]
Subquery with variable in where
Question : I don’t know why but if I do the subquery where in the first LEFT JOIN with the […]
Stored Procedure returns different results in SSMS vs C# code
Question : I have a stored procedure that when executed in SSMS returns different values than when the same SP […]
Effect on execution plans when a table variable has a primary key
Question : Having read a great deal about the differences between temporary tables and table variables in SQL Server, I […]
Should I use tempdb or memory optimized table variable?
Question : I would like to change some of my stored procs to use memory optimized tables. Before I do […]
use a table as a variable [duplicate]
Question : This question already has answers here: Dynamic Server Name in SQL Statements (from clause) (3 answers) Parameterize table […]
Why must TVPs be READONLY, and why can’t parameters of other types be READONLY
Question : According to this blog parameters to a function or a stored procedure are essentially pass-by-value if they aren’t […]