Wayne's World

Sharing My Love Of Business Software & Technology

Author: Wayne

Visual Studio Navigation Bar Option

From time to time I am working away in Visual Studio and I loose the ability to select my methods to jump to.

I have to turn it back on in the options. If this happens to you, you can find this option in the “Text Editor” option with the “Navigation Bar” check box.

Hope this helps if you are occasionally having the same issue:

Navigation

SQL To Show Storage By Tables

I needed to look at all of my tables in SQL server (2014) to see which on had the most rows and took up the most storage.

This was a handy SQL statement:

SELECT
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
sys.tables t
INNER JOIN
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
    sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
    sys.schemas s ON t.schema_id = s.schema_id
WHERE
    t.NAME NOT LIKE 'dt%'
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
GROUP BY
    t.Name, s.Name, p.Rows
ORDER BY
t.Name

Hope you find it useful as well.

Error writing MIME multipart body part to output stream

After publishing a new APS.net site to IIS, one of the functions of the site was failing which was (of course) working on my virtual machine used for development.

The issue was with a file upload and it kept returning me the error on the logs “Error writing MIME multipart body part to output stream”.

It turns out when you publish there is a temporary folder which you set in code that hold the stream and then, once uploaded performs your tasks.

Dim root As String = HttpContext.Current.Server.MapPath("~/App_Data")

NewImage

To solve this you simply have to add this folder to the virtual folder that hold your site and you will be good to go.

Hope this helps!

New Beginning in 2017

Getting ready for 2016 to leave us behind and start fresh in 2017.  To that end, I have once again taken down my site and replaced it with a WordPress site. I think once twitter came along, a lot of the content I would have blogged about I just made quick references about on twitter.  There were plenty of times though that I learned something really useful and I didn’t post it because it didn’t fit in 140 charters and I was too busy to say more about it.

I am planning on changing that and being more prolific in 2017 by blogging more often.

So I am hoping that this site will spring back to life with tons of new, frequently updated information from me about coding, business, apps and my general thoughts.

Hope you find something of use here as I go and thanks for stopping by.

© 2017 Wayne's World

Theme by Anders NorenUp ↑