Using T-SQL query options in CTEs

Long story short: I have a SSIS data transformation task which takes some data from a table and inserts it in a different table.

So far so good. But the problem is that the data source in my transformation relies on a query which gets data from a table with several million rows and in reality

Continue reading […] Using T-SQL query options in CTEs […]

 

Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues

The real professional inspiration comes not from quantity but from quality. This becomes even more obvious by the thin book written by Rick A. Morelan and Pinal Dave on ‘SQL Performance Tuning techniques using wait statistics, Types and Queues’.

 

The topic is indeed one of the most often misunderstood and underestimated ones in performance tuning; and

Continue reading […] Book review: SQL Performance Tuning techniques using wait statistics, Types and Queues […]