Author: VidhyaSagar
-
Pros and Cons of Partitioning
This article describe pros and cons of partitioning in SQL Server
-
Systables related to partitioning
Below listed are the systables which can be used to get information regarding partitioned tables, indexes are views.
-
How Partitioned table works
Partitioning is nothing but dividing of datas according to the requirement to improve query performance. Consider you are having a table with large number of datas. Here in table partitioning we are going to implement horizontal partition, where the rows in the table will be based on one the column in table.
-
Advantages & Disadvantages of Database Mirroring
Advantages Database Mirroring:
-
Comparison between Mirroring VS Log shipping and Mirroring VS Clustering
Database Mirroring Vs Clustering