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:
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:
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
sys.indexes i ON t.OBJECT_ID = i.object_id
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
t.Name, s.Name, p.Rows
Hope you find it useful as well.
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")
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!
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.