select
tb.TABLE_SCHEMA as TableSchema,
tb.TABLE_NAME as TableName,
sum(
Case When DATA_TYPE = 'int' then 4
else 0 end
+
Case When DATA_TYPE = 'nvarchar' and CHARACTER_MAXIMUM_LENGTH > 0 then CHARACTER_MAXIMUM_LENGTH * 2 When DATA_TYPE = 'nvarchar' and CHARACTER_MAXIMUM_LENGTH < 0 then
8000
else 0 end
+
Case When DATA_TYPE = 'varchar' then CHARACTER_MAXIMUM_LENGTH else 0 end +
Case When DATA_TYPE = 'Char' then CHARACTER_MAXIMUM_LENGTH else 0 end +
Case When DATA_TYPE = 'nchar' then CHARACTER_MAXIMUM_LENGTH * 2 else 0 end +
Case When DATA_TYPE = 'decimal' then 8 else 0 end
+
Case When DATA_TYPE = 'bit' then 1 else 0 end +
Case When DATA_TYPE = 'Tinyint' then 1 else 0 end +
Case When DATA_TYPE = 'Smallint' then 2 else 0 end +
Case When DATA_TYPE = 'Smallint' then 4 else 0 end +
Case When DATA_TYPE = 'Smalldatetime' then 4 else 0 end +
Case When DATA_TYPE = 'Smallmoney' then 4 else 0 end +
Case When DATA_TYPE = 'Bigint' then 8 else 0 end +
Case When DATA_TYPE = 'Datetime' then 8 else 0 end +
Case When DATA_TYPE = 'Datetime2' then 8 else 0 end +
Case When DATA_TYPE = 'Float' then 8 else 0 end +
Case When DATA_TYPE = 'Money' then 8 else 0 end +
Case When DATA_TYPE = 'Numeric' and Numeric_Precision > 18 then 16 else 0 end +
Case When DATA_TYPE = 'Numeric' and Numeric_Precision <= 18 then 8 else 0 end +
Case When DATA_TYPE = 'Time' then 8 else 0 end +
Case When DATA_TYPE = 'TimeStamp' then 0 else 0 end +
Case When DATA_TYPE = 'Uniqueidentifier' then 16 else 0 end ) Size_of_Row
from INFORMATION_SCHEMA.COLUMNS c,INFORMATION_SCHEMA.TABLES tb where c.TABLE_NAME =tb.TABLE_NAME group by tb.TABLE_NAME,tb.TABLE_SCHEMA
Atho or Athouk . These consist of boiled noodles cooked with spices, shredded cabbage, onions, chili flakes, roasted channa dal powder, tamarind juice, bejo, garlic oil, coriander leaves and etc are the ingredients of Athouk. To give the dish a crunchy feel. This food also eaten with the accompaniment of Mohinga,a soup made with fish broth & plantain stem, onion, ginger, garlic, chili, turmeric and rice flour. It is an awesome combination. Mohinga , which is considered the unofficial Burmese national food. It is essentially rice noodles served in fish broth with fried onions, garlic, ginger and sliced tender core of plantain stem. If you ask for it, it will also be served with boiled eggs. It is essentially a soup meal and a delightful one at that. History: Many Tamils were settled in Burma then and slowly emigrated back here after Independence.Burmese people started migrating to India. Most of them arrived at the Chennai Port and used to leave for other smaller cities by
Comments