Answer Posted / Pitamber Arya
Partitioned views in SQL Server are similar to regular views but consist of multiple physical partitions. Partitioning allows large data volumes to be divided into smaller, more manageable pieces, improving query performance and reducing resource consumption. Each partition can reside on a different file group, which can be located on separate disk drives or storage devices.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I find the sql server version?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are the different types of subquery?
What are the kinds of subquery?
What are the source of constraints?
Can sql servers link to other servers like oracle?
What is self contained sub query?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what is spatial nonclustered index
What is sql server query analyzer?
Can we do dml on views?
How to remove duplicate rows from table except one?
How to rebuild the master database?
What is clustered index
How can we solve concurrency problems?
