Optimization Of Stored Procedure In SQL Server

This article describes that how we can optimize the Stored Procedures so that we can get better performance while our application is talking to database. I am enlisting some of the points from my personal experience.

 

1)    Always Use Fully Qualified Name For All Database Objects:

While working with stored procedure we need to pass name of database objects (table, view, function, other stored procedure(s) etc.) several times. I recommend every developer to use fully qualified object names instead of using only object name. There is a very strong reason behind this recommendation.

• 
  

  SQL server always has to find supplied database object name from sys object that took some millisecond of processing time and consumption of CPU resources. And if, we pass fully qualified name then that processing time and CPU resource consumption to search the object from sys objects get reduced to significant amount.

  
  


• 
  

  Another reason behind the scene is it helps SQL Server to directly finding the Complied Cache Plan if available instead of searching the objects in other possible schema. This process of searching and deciding a schema for a database object leads to COMPILE lock on stored procedure which decreases the performance of a stored procedure.

  
  

Overview Of List Type In C#.NET

List Class : List is a member of System.Collection namespace in .NET which is having lots of features. 

Declaration: List is declared as follows. 

               List<int> list = new List<int>(); 

Description:

1. 
   

   List type in C# resizes itself if required hence you don’t need to worry for size of List.

   
   


2. 
   

   Used for Linear Collection which are not accessed by Keys.

   
   


3. 
   

   Lists are considered generics and constructed types.

   
   


4. 
   

   We must have to use <> (angle bracket) in the List declaration.

   
   


5. 
   

   It provides many attributes and methods to work with List type; some of them are described with example below. 

Xml manipulation in ASP.NET using C#

HI guys,
While working with Xml using C# ,yesterday i found it very simple. We can easily create, modify and delete nodes in Xml files. So its not a bif deal to work with it. So i simply give you an example od working with Xml file which is consumed by a web service and displaying records from Xml into a GridView in asp.net page. Following is the sample.

How to improve code performance using jQuery

Hi guys,
In this article i am enlisting some of the very important points which every developer need to consider while working with jQuery to enhance the performance of code . Examples would be generating very long tables with a lot of rows using AJAX to get JSON data. Or iterating through a long (very long) list of data, etc.

How to improve performance of web application or portal

In this article i will explain some of the points that all developers must be familiar. Whenever we are planning to develop a web application or web portal we must know these point so that performance of our application is good. So following are the considerable points:--

• Turn off Tracing unless until required

Tracing is one of the wonderful features which enables us to track the application's trace and the sequences. However, again it is useful only for developers and you can set this to "false" unless you require to monitor the trace logging.