Sql

Sometimes you have a series of stored procedures that themselves are managed by another master stored procedure like so. This usually just means a series of EXEC statements after each other. It is quite handy to create a login event after each stored procedure call in order to check its progress. Logging with try-catch CREATE PROCEDURE loging AS BEGIN DECLARE @LogText nvarchar(max) EXEC Staging.SpVV_logIns 'procedure_name_to_log', 'START', null, 'I' BEGIN TRY begin tran --sql code commit EXEC Staging.

Columnstore A columnstore index can provide a very high level of data compression, typically by 10 times, to significantly reduce your data warehouse storage cost. For analytics, a columnstore index offers an order of magnitude better performance than a btree index. Columnstore indexes are the preferred data storage format for data warehousing and analytics workloads. Starting with SQL Server 2016 (13.x), you can use columnstore indexes for real-time analytics on your operational workload.