Finding Dependency Clusters

Michael J. Swart performs cluster analysis with tables:

That ball of mush in the middle is hard to look at, but the smaller disconnected bits aren’t! Just like Ben, I want to work on those smaller pieces too! And just like the lonely tables we looked at last week, these small isolated components are also good candidates for extracting from SQL Server.

The script looks at joins in execution plans, which is a rather clever way of doing this when you don’t have a comprehensive set of foreign key constraints.

Related Posts

The Power of Hexagonal Binning

Capri Granville explains hexagonal binning to us and gives a few examples: The reason for using hexagons is that it is still pretty simple, and when you rotate the chart by 60 degrees (or a multiple of 60 degrees) you still get the same visualization.  For squares, rotations of 60 degrees don’t work, only multiples […]

Read More

Choosing Colors for Visuals

Lewis Chou has some advice for choosing color schemes for data visualization: When making a chart, we should use the same color scheme for the same metrics. And we need to avoid the excessive color interference to the user. For example, when we do sales analysis, we usually analyze the indicators of sales and payment […]

Read More

Categories

April 2019
MTWTFSS
« Mar May »
1234567
891011121314
15161718192021
22232425262728
2930