Tips for using temporary tables in SQL Server 2017 Consider creating indexes on the very large temporary tables. The temporary tables provides much more efficient way to access their data in comparison with general tables, but if you work with very large temporary tables, using indexes can greatly improve performance. Use Table data type instead of temporary tables whenever possible....
Tag: CTE
Some tips for using temporary tables in SQL Server 2016
Some tips for using temporary tables in SQL Server 2016 Consider using system-versioned temporal tables. A system-versioned temporal table is a new type of user table in SQL Server 2016 that provides correct information about stored facts at any point in time. Each temporal table consists of two tables actually, one for the current data and one for the historical...
SSIS Package Error
SSIS Package Error "A rowset based on the SQL command was not returned by the OLE DB provider.” while using Stored Procedure as Source. Scenario: Lately I’ve come up with a unique requirement in which data movement is required from SQL Server source and multiple nested conditions left me with no other condition but to use Stored Procedure as source....