December 2010 - Posts

• Sybase ASE

  I sat in a Sybase ASE class last week for five days. Although it didn't cover the more advanced features introduced in the more recent versions of Sybase ASE, the class did touch all the basics of administering Sybase ASE. While I was successful in suppressing Read More... Posted Friday, December 10, 2010 10:39 PM by Linchi Shea | 5 Comments Filed under: Sybase ASE

• Linked servers and performance impact: Direction matters!

  When you have some data on a SQL Server instance (say SQL01) and you want to move the data to another SQL Server instance (say SQL02) through openquery(), you can either push the data from SQL01, or pull the data from SQL02. To push the data, you can Read More... Posted Wednesday, December 01, 2010 12:31 AM by Linchi Shea | 6 Comments Filed under: Best Practices, Linked server, Performance