A few interesting things to note about this graphic.
-
The query is an INSERT into myVIEW
-
It is using tempdb to process the INSERT. I think it is because I had to add a SELECT * FROM inserted trigger to even get INSERTs to work. In addition I had to add a WHERE clause matching the partioned tables CHECK constraint and explicitly insert to the appropriate table.
-
I thought tempdb needed to have the data files all the same size to be utilized. So here we can see the files which are the same size are used, the bigger one is not.
ps. This is a test. The files will be the same size after the server is restarted.