SQL Database Concepts Question: Download Questions PDF
Tell me in brief how SQL server enhances scalability of the database system?
Answer:
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.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain what are Sparse columns? | Do you know what is RANK function? |