Discovering New Things at the Technology..,

Thursday, July 14, 2011

ASP.NET Best Practices for High Performance in your Applications!!

I found some great articles on Best pracites and improving the performance of ASP.NET application. Check out these great articles.
Practice Article 1
Practice Article 2
Practice Article 3

How to display your own logo in the address bar?

If you need to put your website logo in the top address bar instead of browser's logo then follow these steps.
1. Add a file called "favicon.ico" (an icon file of your website logo) to your website root directory.
2.Insert the following HTML tag inside the <head> ... </head> section of your web page.
<link rel="shortcut icon" href="favicon.ico" >

**If you are working with master pages then put this code in head section of master page otherwise you have to put this code in every page.

Asp.net Articles..Refer it.

I found a great post, which focuses on ASP.NET Coding Standards. These standards should be considered while working with ASP.NET application.

You can read the article Click here.

15 New Features of jQuery 1.4 download below link..

jQuery 1.4 was recently released. There are many new features, enhancements and performance improvements included in 1.4!
You can download jQuery 1.4 right now, here:http://code.jquery.com/jquery-1.4.js
Check this article to know 15 New Features of JQuery 1.4

Thanks,
s.c

Get list of all currently running procedure in SQL Server..

Sometimes it is a need to find out which stored procedure are running on the SQL Server.Below SQL query will provide the list of stored procedure which are currently running on the server.

SELECT OBJECT_NAME(ObjectID) as ObjectName,
  st.Text, 
  DB_NAME(database_ID) as dbname,
  Blocking_session_ID as BlockingSessionID,  
  *
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st

Retrieve Table Name from all the Procedures of any database..

In Sql Server 2000 or later versions,

Suppose you have deleted one of the column of any table and now you have to change all your procedures where this column is used.

1. One way is to open every procedure and look for the table and the cloumn name.

2. Second solution is the

Select * from information_Schema.Routines where Routine_Definition like '%table1%'

This Query will allow to find out whether table name specified in where conditoin exists in which Procedures.
INFORMATION_SCHEMA.ROUTINES view is used to retrieve information about stored procedures. This view contains one row for each stored procedure accessible to the current user in the current database.

The INFORMATION_SCHEMA.ROUTINES view was introduced in SQL Server 2000. This view is based on the sysobjects, syscomments and other system tables.

Count number of tables in a SQL Server database..

A simple query to find out number of tables in database is

USE SLINGKAST

SELECT COUNT(*) from information_schema.tables
WHERE table_type = 'base table'