Wednesday, May 13, 2015

Chrome: Could not load shockwave flash

I had an expired Flash - Firefox. For some weird reason, I made an upgrade. (I don't really use Firefox)
This messed up my Chrome Flash. I had "Could not load shockwave flash", and that nice looking grey thing.
Went on to google it, tried several things.

  • chrome setting, something needs to be disabled (when you have 2 plugins)
  • delete some files from some flash folder on C drive
  • uninstall plugins, reinstall them

Nothing worked.

I finally uninstalled chrome, and reinstalled it. I didn't lose anything. Browsing history, shortcuts, home page, extensions (even an extension that is no longer in Chrome app store).

Flash also worked flawlessly after this.

Thursday, April 9, 2015

How to get the size of the tables in a database

How to get the size of the tables in a database
SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
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
TotalSpaceKB desc
Thanks to Andrew