Author Archives: zmided

Top Ten (well almost) Best Practices for Knowledge Transfer (KT)

Posted on by
Reply

Here are some quick tips for managing the knowledge transfer (KT) process. If done RIGHT, not only will your resources ramp up quickly, but they will also be able to generate a repository of information that will facilitate KT for resources that are added to the project in the future.…

Managing Large Data Sets in SQL Server 2005 and 2008

Posted on by
Reply

Overview
One of SQL Server’s strengths is its ability to operate against multiple rows using just one statement, but in excess that strength can be problematic. For example, performing an insert of 20 million rows will place numerous page locks and possibly a table lock on that table, which can…