Microsoft BizTalk France

Have you ever had a table that kep growing, while the performaces kept degrading, the first nice idea  would be to define indexes, fair enough, but as the table continues to grow so does the indexes, and still the indexes might not be sufficient. So what do you do? buy a more powerful server? 

Well this is an extreme solution, before just try to partition your huge table (well what is huge? above 10Gb is already huge in my case)

Partitionning is equivalent to create as many smaller objects as your partition boundaries

Tags: transfer | existing table | SQL Server | Partition | Table | schema | function

Hits: 8460 | Read more...