I was trying to upgrade my MACD technical analysis calculation to use the new In Memory … Error 3624 when creating natively compiled stored procedureRead more
Month: May 2014
Sorted data flows in SSIS
Sometimes a data flow in SSIS needs to be sorted. It may be because the business … Sorted data flows in SSISRead more
Add missing lookup in SSIS
Before a fact table is loaded, a common pattern is to do a lookup in SSIS … Add missing lookup in SSISRead more
T-SQL function SERVERPROPERTY
The T-SQL function SERVERPROPERTY returns a lot of properties about the current SQL Server instance. The … T-SQL function SERVERPROPERTYRead more
Table Valued Parameters in Stored Procedures
In most cases stored procedures are developed so that it accepts a number of input parameters … Table Valued Parameters in Stored ProceduresRead more