Explain how SQL server enhances scalability of the database system

Explain in brief how SQL server enhances scalability of the database system.

SQL Server has efficient ways to enhance scalability of the database system. 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, thus allowing the complete result set to build faster.
SQL Server English Query - What is SQL Server English Query?
SQL Server English Query - SQL Server English Query helps to build applications that can accept query in questions......
What is the purpose of SQL Profiler in SQL server?
SQL Server Profiler - SQL Profiler captures SQL Server events from a server. The events are saved in a trace.....
Ways available in SQL Server to execute SQL statements
SQL Server uses different ways to execute SQL statements which are listed below.......
Post your comment