Monday, August 2, 2010

How to identify your SQL Server version and edition

How to identify your SQL Server version and edition


Run the below command in your SQL Server Query Window:


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


Pl. Note: This command will work in SQL 2008, 2005, 2000. not in SQL 7

Friday, July 30, 2010

Compression in IIS 6.0

Guys, Pl. dont miss this if you are using IIS 6,

Pl. find the link for how to implement Compression in IIS 6:



Scott Forsyth's Blog


Enabling HTTP Compression - Microsoft


Customizing the File Types IIS Compresses - Microsoft

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