Hello again. You all probably heard here and there that separating data from the indexes is good. Some of you even went down that road and actually did it. Which is good. There are also a ton of articles on this topic and the ones that come quickly to my mind are the ones authored … Continue reading Why is important to separate data from indexes
Tag: performance tuning
Aggregation and partitioned tables
One of my main tasks is to keep a close eye on performance. Every time we have a major release, I have to start looking at performance, find main culprits and fix them. Well, not me, but work with developers and find a solution to the issues at hand. And our databases are rather large, … Continue reading Aggregation and partitioned tables