tag:blogger.com,1999:blog-74825154033020270892024-02-08T23:01:46.327+05:30Tamil DOt NEtTamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7482515403302027089.post-75873385046695906252010-08-02T10:37:00.003+05:302010-08-02T10:45:45.822+05:30How to identify your SQL Server version and edition<span style="font-size:85%;"><span style="font-family: trebuchet ms;">How to identify your SQL Server version and edition</span> </br><br /><br /><span style="font-family: trebuchet ms;">Run the below command in your SQL Server Query Window:<br /><br /></span></span><span style="font-style: italic; font-family: trebuchet ms;font-size:85%;" ><br /><span style="font-size:85%;"><span style="font-family: arial;">SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')<br /><br /></span></span></span><span style="font-size:85%;"><br /><span style="font-family: trebuchet ms;">Pl. Note: This command will work in SQL 2008, 2005, 2000. not in SQL 7</span></span>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-62605972361415460252010-07-30T11:28:00.007+05:302010-07-30T11:52:23.788+05:30Compression in IIS 6.0<span style="font-size:85%;"><span style="font-family: verdana;">Guys, Pl. dont miss this if you are using IIS 6,</span><br /><br /><span style="font-family: verdana;">Pl. find the link for how to implement Compression in IIS 6:</span> </br> </br><br /><br /><a style="font-family: verdana;" href="http://weblogs.asp.net/owscott/archive/2004/01/12/57916.aspx">Scott Forsyth's Blog</a></br><br /><br /><a style="font-family: verdana;" href="http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/502ef631-3695-4616-b268-cbe7cf1351ce.mspx?mfr=true">Enabling HTTP Compression - Microsoft</a></br><br /><br /><a style="font-family: verdana;" href="http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/5bce429d-c4a7-4f9e-a619-5972497b932a.mspx?mfr=true">Customizing the File Types IIS Compresses - Microsoft</a></span></br>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-51601071868421217442010-01-18T16:26:00.002+05:302010-01-18T16:29:12.257+05:30Reasons For Choosing WPF Over ASP.NET For Our Very Large ProjectGood article on WPF Vs Asp.Net:<br /><br /><a href="http://karlshifflett.wordpress.com/2007/12/20/reasons-for-choosing-wpf-over-aspnet-for-very-large-project/" target="_blank">http://karlshifflett.wordpress.com/2007/12/20/reasons-for-choosing-wpf-over-aspnet-for-very-large-project/</a>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-39523914753959955262009-10-05T14:21:00.002+05:302009-10-05T14:24:07.731+05:30Visual Studio Debugging Tips and TricksVisual Studio Debugging Tips and Tricks:<br /><br /><a href="http://blogesh.wordpress.com/2008/09/09/visual-studio-debugging-tips-and-tricks/" target="_blank">http://blogesh.wordpress.com/2008/09/09/visual-studio-debugging-tips-and-tricks/</a>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-11456580449415495232009-09-10T13:25:00.003+05:302009-09-10T13:34:02.092+05:30Find Size of Tables and Database in SQLTo know the size of tables in the database:<br /><br /><span style="font-style: italic; font-family: trebuchet ms;"></span><span style="font-style: italic;">select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8) + ' KB' from sysindexes where indid in (0,1) order by dpages desc</span><br /><br /><br />To Know the size of the databases in the server:<br /><br /><span style="font-family: trebuchet ms; font-style: italic;">SELECT name, size * (8192/(1024.*1024)) FROM sys.master_files ORDER BY size DESC </span>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-26499778157671505552009-08-31T17:57:00.000+05:302009-08-31T17:59:39.823+05:30Results of AJAX Statistic for .NET DevelopmentPl. check below URL to know AJAX Statistic for .NET Development:<br /><br />http://weblogs.asp.net/mschwarz/archive/2009/06/23/results-of-ajax-statistic-for-net-development.aspxTamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-81646521053419842132009-05-14T12:17:00.004+05:302009-08-31T18:06:21.954+05:30Useful SQL Blog<span style="font-family: trebuchet ms;">Hi all,</span><br /><br /><span style="font-family: trebuchet ms;">I'm back with few userful SQL blogs / sites</span><br /><br /><a style="font-family: times new roman;" href="http://weblogs.sqlteam.com/jeffs/Default.aspx" target="_blank">http://weblogs.sqlteam.com/jeffs/Default.aspx</a><br /><a style="font-family: times new roman;" href="http://blog.sqlauthority.com/" target="_blank">http://blog.sqlauthority.com/</a><br /><a style="font-family: times new roman;" href="http://www.sqlteam.com/" target="_blank">http://www.sqlteam.com/</a><br /><a style="font-family: times new roman;" href="http://weblogs.sqlteam.com/brettk/Default.aspx" target="_blank">http://weblogs.sqlteam.com/brettk/Default.aspx</a><br /><br /><br /><span style="font-family: trebuchet ms;">Check out. </span>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com1tag:blogger.com,1999:blog-7482515403302027089.post-19056903210887671422008-09-09T11:31:00.003+05:302008-09-09T17:24:31.709+05:30Microsoft Visual Studio 2008 Service Pack 1 Offline Installer<span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" >Hi all,</span><span style="font-family: trebuchet ms;font-size:85%;" ><br /><br />Whoever don't have internet connection and want to install Visual Studio 2008 SP1.<br /></span><span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" >You can download Complete Service Pack 1 </span><span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" > (832 MB) </span><span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" >Installer in </span><span style="font-family: trebuchet ms;font-size:85%;" ><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=27673C47-B3B5-4C67-BD99-84E525B5CE61&displaylang=en" target="_blank">this link</a></span><span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" >. It doesn't requires internet connection while Installing.</span><span style="font-family: trebuchet ms;font-size:85%;" ><br /><br /></span><span style="font-family: trebuchet ms;font-family:trebuchet ms;font-size:85%;" ><a href="http://codebetter.com/blogs/patricksmacchia/archive/2008/08/13/net-3-5-sp1-changes-overview.aspx" target="_blank"><br /></a></span>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com0tag:blogger.com,1999:blog-7482515403302027089.post-26085157564509402682008-08-27T12:44:00.003+05:302008-09-04T17:59:19.283+05:30Manipulate DateTime in T-SQL - Part 1<span style="font-size:85%;"><span style="font-family:trebuchet ms;">This is my first post in this blog and I'm going to start with a simple task.<br /></span><br /><span style="font-family:trebuchet ms;">In Sql 2005 to store Date / Time / Date&Time we have only two Data types:</span><br /><br /></span><ul><li><span style="font-size:85%;"><span style="font-family:trebuchet ms;">DateTime</span></span></li><li><span style="font-size:85%;"><span style="font-family:trebuchet ms;">SmallDateTime</span></span></li></ul><span style="font-size:85%;"><br /><span style="font-family:trebuchet ms;">In 2005 we didn't any datatype to store Date or Time value alone. </span><span style="font-family:trebuchet ms;">To overcome this issue, here we want to remove/Ignore the Time value from DateTime.<br /><br /></span><span style="font-family:trebuchet ms;">Before starting this operation, first I'd like to say that DateTime values are stored in numeric value. Execute below Query to understand it.</span><br /><br /><span style="color: rgb(0, 153, 0);font-family:courier new;" >SELECT CONVERT (DATETIME, 0)<br /></span></span><span style="font-size:85%;"><span style="color: rgb(0, 0, 153);font-family:courier new;" >-- Output: 1990-01-01 00:00:00.000<br /></span></span><span style="font-size:85%;"><span style="font-family:courier new;"><span style="font-style: italic;">–- Initial value of DateTime is 1990-01-01 (In Numeric value is "0")<br />-- We can increase or decrease DateTime value using Numeric values</span></span></span><br /><span style="font-size:85%;"><br /><span style="color: rgb(0, 153, 0);font-family:courier new;" >SELECT CONVERT (DATETIME, 31)<br /></span><span style="color: rgb(0, 0, 102);font-family:courier new;" >-- Output: 1900-02-01 00:00:00.000<br /></span><br /><span style="color: rgb(0, 153, 0);font-family:courier new;" >SELECT CONVERT (DATETIME, -31)</span><br /><span style="color: rgb(0, 0, 102);font-family:courier new;" >-- Output: 1899-12-01 00:00:00.000<br /></span><br /><span style="font-family:courier new;"><span style="color: rgb(0, 153, 0);">SELECT CONVERT (float, getdate())</span> </span><br /><span style="color: rgb(0, 0, 102);font-family:courier new;" >-- Displays 39685.6186604167<br /></span></span><span style="font-size:85%;"><span style="font-family:courier new;"><span style="font-style: italic;">–- Current Date time : 2008-08-27 14:51:50.610</span></span></span><br /><span style="font-size:85%;"><span style="font-family:trebuchet ms;"><br />In the above result, 39685 <span style="font-style: italic;">(2008/08/27- 1900/01/01 = 39685 days)</span> is value of days and .6186604167 is value of time (After decimal point values). So if we remove time values we can get the Date values alone.</span><br /><br /><span style="font-family:trebuchet ms;">Ex:</span><br /></span><span style="font-size:85%;"><span style="color: rgb(0, 153, 0);font-family:courier new;" >SELECT CAST (FLOOR (CAST (getdate() as float) ) as datetime )</span><br /><span style="color: rgb(0, 0, 102);font-family:courier new;" >-- Displays 2008-08-27 00:00:00.000</span><br /><br /></span><span style="font-size:85%;"><span style="font-family:trebuchet ms;">Floor function is used to round-off float value. </span><br /><br /><span style="font-family:trebuchet ms;">Note: In SQL 2008, we have datatype to store <a href="http://msdn.microsoft.com/en-us/library/bb630352.aspx" target="_blank">Date</a> or <a href="http://msdn.microsoft.com/en-us/library/bb677243.aspx" target="_blank">Time</a> value separately </span><br /><br /><br /></span>Tamil Mannanhttp://www.blogger.com/profile/15853761675075314879noreply@blogger.com2