Thursday, September 10, 2009

Find Size of Tables and Database in SQL

To know the size of tables in the database:

select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8) + ' KB' from sysindexes where indid in (0,1) order by dpages desc


To Know the size of the databases in the server:

SELECT name, size * (8192/(1024.*1024)) FROM sys.master_files ORDER BY size DESC

Monday, August 31, 2009

Results of AJAX Statistic for .NET Development

Pl. check below URL to know AJAX Statistic for .NET Development:

http://weblogs.asp.net/mschwarz/archive/2009/06/23/results-of-ajax-statistic-for-net-development.aspx