On a daily basis our organization has hundreds of SQL Server Integration Services (SSIS) processes that move data between systems for real time reporting, data warehousing, data exchanges with other organizations and more. As our business evolves and grows we are building more code and constantly updating the code. Working with the rich SSIS tool set was originally very beneficial with our small team and the overall engine has been reliable, bu
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APPLY operator becomes evident when you have a table-valued expression on the right side and you want this table-valued expression to be evaluated for each row from the left table expression. In thi
Stored procedures and functions are the mainstay of SQL Server coding. In this session you will learn techniques to locate problematic code and to improve the performance of procedures and functions.
Step one is to discover where the time is going using standard server traces, code that analyzes the trace, and the new SQL Server Extended Events. Once we know where the time is going we will look at strategies to improve performanc