
Mohan
blogs from Chennai


A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects The use of schemas can help to combine entities from separate applications or functional areas, or logical groups, into a single physical database. One example of relevance is the protection...
Posted on 14 September 2010 | 1:53 pm
Read postPoints to remember when Bulk-Loading Data We use different Import mechanisms (BCP , Bulk Insert or SSIS) to bulk-load data , we should consider the following factors to get top performance1.Disable indexes and Bulk-load data The best scenario is bulk- loading data into an empty heap ( a table with n...
Posted on 8 June 2010 | 1:53 pm
Read postData Tracking Solutions SQL Server 2008 introduces two tracking features that enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables in a database.1.Change Data capture2.Change TrackingBefore these features were available, custom tracki...
Posted on 23 May 2010 | 8:55 pm
Read post