seen from United States
seen from Norway
seen from United States
seen from India
seen from China
seen from United States
seen from United States
seen from United States
seen from United States
seen from Canada
seen from United States
seen from Japan
seen from United States
seen from Canada
seen from Australia
seen from United States
seen from United States
seen from United States
seen from Egypt
seen from Singapore
Partitioned for Performance
If you’ve done any of the Microsoft training or certifications in the last few years, you’ll probably noticed they’re really pushing for the use of partition tables-it’s appeared in at least 3 of my exams for the MSCA/MSCE. In my opinion, that’s a probably a good move as I believe partitioned tables are another one of those great features on SQL that’s not used as often as it should despite the…
View On WordPress
Horizontal Partitioning for Big Tables
It’s fairly common knowledge amongst database professionals partitioned tables can help considerably with performance in various situations but my guess is not many would have considered the enormous benefits when it comes to archiving, a necessity when it comes to massive tables.
SQL Server 2017 supports up to 15,000 partitions by default. In versions earlier than SQL Server 2012, the number of partitions was limited to 1,000 by default
It’s fairly common knowledge amongst database professionals partitioned tables can help considerably with performance in various situations but my guess is not many would have considered the enormous added benefits when it comes to…
View On WordPress
