SQL - Truncate and Delete(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

Truncate an Delete both are used to delete data from the table. These both the command will only delete the data of the specified table, they cannot remove the whole table data along with its structure. Now it’s ok that both the SQL statements are used to delete only the data from the table but they both differ from each other in many aspects like syntax, performance, resources uses etc. to find out all differnces take a look of this article..... read more...

1 comment |category: Database |Views: 7

tags: TSQL TechAhead SQLServer Database SQL another

ASP.NET - Server.Transfer v/s Server.Execute(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

Difference between Server.Transfer and Server.Execute. read more...

3 comments |category: ASP.NET |Views: 87

tags: Server.Execute TechAhead ASP.NET Server.Transfer another

ASP.NET - Server.Transfer v/s Response.Redirect(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This article tell you the difference between Server.Transfer and Response.Redirect. read more...

7 comments |category: ASP.NET |Views: 67

tags: Response.Redirect TechAhead ASP.NET Server.Transfer another

Improving The Page Flow Application Block(msmvps.com)

submitted by PauloMorgado(435) 4 years, 7 months ago

In this series of articles the author shows how (in his opinion, obviously) the Page Flow Application Block of the Web Client Software Factory could be improved. read more...

add a comment |category: ASP.NET |Views: 7

tags: ASP.NET another

SQL – Using "UNION ALL" to Convert Horizontal Data to Vertical Data(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This post will tell u how to use the UNION ALL operator to convert horizontal data to vertical data. read the post more more information....... read more...

add a comment |category: Database |Views: 330

tags: TSQL TechAhead SQLServer Database SQL another

.NET - Basic oops terms used in .NET(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

Hi, This article introduse you with some of the basic oops terms and .net basic terms used in .NET framework. read more...

7 comments |category: VB.NET |Views: 125

tags: .net2.0 TechAhead VB.NET .Net another

SQL - Derived tables(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This article explains what are derived tables and how we can use them to perform our query better. In some situations they can be a better alternative of temporary tables, So take a look of this... :) read more...

add a comment |category: Database |Views: 89

tags: TSQL TechAhead SQLServer Database SQL another

Speed Up Your Site! 8 ASP.NET Performance Tips(sitepoint.com)

submitted by k000der(4765) 4 years, 7 months ago

Sample chapter from the book "The ASP.NET 2.0 Anthology". Many nice tricks to improve the performance of you site/app. read more...

4 comments |category: ASP.NET |Views: 93

tags: JonGalloway CodingHorror Performance ASP.NET another

SQL - Temporary tables a detailed view.(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This article contains almost each and everything related to temporary tables in SQL, all the concepts of temp tables like how to use them, wht are the alternatives of temp tables, what are the benefits and drwabacks, what is the performance tunibg tips etc, i think this is the best article to learn about SQL Server Temporary tables. read more...

add a comment |category: Database |Views: 123

tags: Temporary tables TechAhead TSQL Database another

It's Time for Microsoft to Make SQL Server Hosting Free.(ironruby.blogspot.com)

submitted by softmind(115) 4 years, 7 months ago

My Biggest Question and Argument...? What sense does it make for Microsoft to bring all languages under one roof, if they are not going to earn from database hosting. If They have no intentions to earn then why charge for SQL Hosting....? Its time for Microsoft to understand this and remove a small yet big hurdle that stops developers reaching towards windows hosting world. read more...

2 comments |category: Community |Views: 2

tags: IronPython IronRuby DotNet Community SQL another

.NET Framework 3.5 Is Shared Source(weblogs.asp.net)

submitted by benrick(1020) 4 years, 7 months ago

Microsoft's .NET Framework 3.5 is going to be released open source. read more...

26 comments |category: Open Source |Views: 152

tags: Pick SharedSource .net3.5 .Net ScottGuthrie another

You voted lots, we fixed lots [AJAX Control Toolkit release!](blogs.msdn.com)

submitted by k000der(4765) 4 years, 8 months ago

Version 10920 is out with lot's of bug fixes read more...

1 comment |category: AJAX |Views: 2

tags: AJAX.NET AjaxControlToolkit AJAX OpenSource CodePlex another

New T-SQL Capabilities in SQL Server 2005 - Part 1 of 3 (setfocus.com)

submitted by SetFocus(510) 5 years, 2 months ago

This month I'll start a three-part series on new Transact-SQL language features in SQL Server 2005. Microsoft added many new language features in SQL Server 2005, in response to developer requests and also in following compliance with the SQL-99 standard. read more...

add a comment |category: Visual Studio |Views: 32

tags: SQLServer T-SQL TSQL SQL VisualStudio another