Skip to main content


Showing posts from September, 2013

Getting the size of your Microsoft (MS) SQL database

I foudn this at Stack Overflow, and thought it woud be great to save it since it works well. 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 t.Name   It returns a table that you can use to calculate the total size. Original post Get size of all tables in database Obvioulsy you must use the database first.

The new IOS 7 mainly visual changes.

I must admit after all the negative press I was worried about upgrading to the new IOS 7. My iPhone 4 may be old but I decided to upgrade it first.  The download took well over an hour on a 4mb ADSL line (for those none Telkom SA users that is DSL). And after doing a backup in installed this was smooth but did take a bit of time.  So what is all the fuss about? To be totally honest I do jot kown. The main thing that has changed is that icons form apple apps are different and look is similar to Vista's aero look with everything being transparent. The buttons that we got used t are replaced with language based buttons, so delete is replace with trash, the button bars are now like menu commands rather than icon based tool bars.  As far as improvements are concerned, most of the changes are visual, I am sure that there are under the good improvements but the visual changes are what seems to be the main change. Zooming app buttons cool open app scrolling, and finally some multi tasking

Integrative theory Levels - a Summary

From Ken Wilber has composed, I have extracted the below. Each area of development is normally mutually exclusive, except for the last stage which is inclusive. From the many minds of Trans personal Psychology and East-West studies, Ken Wilder and his colleagues have after 2-3 decades came up the notion of at least two different types of components of the mind, there are listed in a tabular form below: Structures of consciousness (the way we grow up) States of consciousness (the way we wake up) archaic magic mythic rational pluralistic integral and higher gross subtle cause based pure witnessing non-dual These are both development sequences. Ken says that each state and structure sees the other states or structures as incorrect, or inferior to the current state, except for integral or non-dual, which sees all the states for what they are and how they are needed. By the way structures are how we think, and states are essentially our level of spiritual aw