Visual Studio Debugging Tips and Tricks:
http://blogesh.wordpress.com/2008/09/09/visual-studio-debugging-tips-and-tricks/
Monday, October 5, 2009
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
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
http://weblogs.asp.net/mschwarz/archive/2009/06/23/results-of-ajax-statistic-for-net-development.aspx
Thursday, May 14, 2009
Useful SQL Blog
Hi all,
I'm back with few userful SQL blogs / sites
http://weblogs.sqlteam.com/jeffs/Default.aspx
http://blog.sqlauthority.com/
http://www.sqlteam.com/
http://weblogs.sqlteam.com/brettk/Default.aspx
Check out.
I'm back with few userful SQL blogs / sites
http://weblogs.sqlteam.com/jeffs/Default.aspx
http://blog.sqlauthority.com/
http://www.sqlteam.com/
http://weblogs.sqlteam.com/brettk/Default.aspx
Check out.
Subscribe to:
Posts (Atom)