Thursday, July 12, 2012

Scalability of Databases in Microsoft SQL Server

Scalability of Database System can be enhanced efficiently by Microsoft SQL Server.

Microsoft SQL Server 2000 automatically adjusts the granularity of locking for each table used by a query. 


Parallel Execution Plans is in placed automatically. This split the processing of a SQL statement into pieces that can be run on a different CPU, which causes the complete result set to build faster.

2 comments:

  1. This Blog deserves far more attention than it is getting right now

    ReplyDelete
    Replies
    1. Can you please clarify, what you think, what kind of attention it require, either post content has to be improved or there should more updates on daily/weekly basis or something else.

      Thanks for your attention.

      Delete