Fractals In SSMS

Slava Murygin gives us a script to generate fractals:

That is most difficult operation. At first, SSMS can’t show more than 5000 separate objects at the same time. In order to show more we have to construct “MULTIPOLYGON” or “GEOMETRYCOLLECTION”. That only the way to fit more objects into SSMS screen. However it is still limited.
In order to combine triangles in a single object we divide them in buckets (Line 106).
In this example I just making number of buckets approximately equal to a number of objects within each bucket. Making lower number of buckets will increase processing speed, but produce less colors. All objects in one collection will have the same color.
Also, I wrapped the last query in extra CTE to have more flexibility on results formation.

This is a fun post showing some of the power and limitations of geometry types in SQL Server and their display in SSMS.

Related Posts

New Management Studio Features

Wayne Sheffield looks at two new features in SQL Server Management Studio 17.3: For this simple test, it worked pretty well, and it should work well for most of the requirements that you have. Time will tell how reliably this new feature does work. The Import Flat File is available when connecting to SQL Server […]

Read More

Power BI Custom Visuals: HTML Viewer

Devin Knight continues his Power BI custom visuals series: In this module you will learn how to use the HTML Viewer.  The HTML Viewer allows you to display the results of HTML code within your Power BI reports. It does what it says on the label, and that’s good enough for me.

Read More

Categories

December 2015
MTWTFSS
« Nov Jan »
 123456
78910111213
14151617181920
21222324252627
28293031