All geek questions in one place

Splitting SQL on a non-corporate server?

I tried using the partition function on my SQL server to split one of my large tables, but I got an error . The Partition function can only be created in the Enterprise edition SQL Server. Only Enterprise Edition SQL Server supports partitioning. . I was wondering how everyone else who does not have an Enterprise version solves this problem?

Any advice would be great!

+4
source share
2 answers

You can create your own split. The simplest: multiple tables and one view to access them. And a unified data change process. There will be some pitfalls, such as uniquefier rows in multiple tables ( distributed PRIMARY KEY ) and many others.

+2
source

Method Oleg Dok means "partitioned view". Microsoft has covered it extensively in SQL 2000 and 2005 documents. Just google this term and you will get a lot of advice.

Basically, if you have N tables with the same schemas, you can create a view above them that combines them together and provides a consolidated view of your data. There is a pretty good blog post describing this. You will encounter some hiccups, especially in terms of performance, so choose indexes wisely, update statistics and monitor them correctly.

+2
source

Source: https://habr.com/ru/post/1390371/

More articles:


All Articles