Export Data from IBM DB2 iSeries to SQL Server One of our clients has an IBM DB2 for iSeries database. Connecting using a traditional DB2 ODBC driver does not work for this type of database platform. I need to move some data from the iSeries to a staging database on SQL Server using SSIS, how can I connect?
SQL Server Cursor Example In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors? I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient mann
100 Times Faster: Experiences making SQL Server Fly How do you make a T-SQL program run a lot faster? Like 100 times faster? Itís difficult. Microsoft tried and got close in the Hekaton project, its in-memory tables feature of SQL 2014. Inspired by that effort, this presentation looks at recent cases where Iíve been able to achieve huge performance improvements in SQL Server using various techniques. Weíll explore how the performance problem was created in the first place and the solution that I e