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
Tamil DOt NEt
Monday, August 2, 2010
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
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
Monday, January 18, 2010
Monday, October 5, 2009
Visual Studio Debugging Tips and Tricks
Visual Studio Debugging Tips and Tricks:
http://blogesh.wordpress.com/2008/09/09/visual-studio-debugging-tips-and-tricks/
http://blogesh.wordpress.com/2008/09/09/visual-studio-debugging-tips-and-tricks/
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)