Sql performance is the main concern to develop a successful and optimized application. Database performance can be increased by following some tips while designing query.

 

Writing an ASP.NET application is relatively easy with the use of Rapid Application Development controls however it is just not enough to use. You should use each component wisely to get performance benefit to your ASP.NET Website.

 

While designing html page we generally got confused that whether we should use div or table. Here I have described advantages and disadvantages for both div and table.

 

Function is compiled and executed every time whenever it is called but Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called.