Happy New Year 2011

The beginning of the new year is a great time to start fresh and work toward the things that you want from life. Pretty much everyone sets goals and objectives for the new year whether privately in their head or publicly to their friends and family.


New Year is a time for celebration, countdown parties, champagne, dancing and fireworks. It’s probably the biggest celebration of the year seeing the last few hours of the old year slip away and the start of a bright new year 2011.

But as with everything that comes to an end, it’s also a time to reflect on the year past and make plans for the year ahead.

Hours of happy times with friends and family
Abundant time for relaxation
Prosperity
Plenty of love when you need it the most
Youthful excitement at life's simple pleasures

Nights of restful slumber (you know - don't worry be happy)
Everything you need
Wishing you love and light

Years and years of good health
Enjoyment and mirth
Angels to watch over you
Remembrances of a happy years!

Merry Christmas

Wishing you all A Merry Christmas …

May you have a wonderful festive season 

SQL - Index

UNIQUE 

 

Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns that already include duplicate values, whether or not IGNORE_DUP_KEY is set to ON. If this is tried, the Database Engine displays an error message. Duplicate values must be removed before a unique index can be created on the column or columns. Columns that are used in a unique index should be set to NOT NULL, because multiple null values are considered duplicates when a unique index is created. 

 

CLUSTERED 

 

Creates an index in which the logical order of the key values determines the physical order of the corresponding rows in a table. The bottom, or leaf, level of the clustered index contains the actual data rows of the table. A table or view is allowed one clustered index at a time. For more information, see Clustered Index Structures. 

 

A view with a unique clustered index is called an indexed view. Creating a unique clustered index on a view physically materializes the view. A unique clustered index must be created on a view before any other indexes can be defined on the same view. For more information, see Designing Indexed Views. 

Create the clustered index before creating any nonclustered indexes. Existing nonclustered indexes on tables are rebuilt when a clustered index is created. 

If CLUSTERED is not specified, a nonclustered index is created. 

 

NONCLUSTERED 

 

Creates an index that specifies the logical ordering of a table. With a nonclustered index, the physical order of the data rows is independent of their indexed order.

 

For More Deatil

The partner transaction manager has disabled its support for remote/network transactions

First verify the “Distribute Transaction Coordinator” Service is
running on both database server computer and client computers
1.      Go to “Administrative Tools > Services”
2.      Turn on the “Distribute Transaction Coordinator” Service if it is not running If it is running and client application is not on the same computer as
the database server, on the computer running database server
1.      Go to “Administrative Tools > Component Services”
2.      On the left navigation tree, go to “Component Services > Computers
> My Computer” (you may need to double click and wait as some nodes
need time to expand)
3.      Right click on “My Computer”, select “Properties”
4.      Select “MSDTC” tab
5.      Click “Security Configuration”
6.      Make sure you check “Network DTC Access”, “Allow Remote Client”,
“Allow Inbound/Outbound”, “Enable TIP” (Some option may not be
necessary, have a try to get your configuration)
7.      The service will restart
8.      BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN’T WORK
(This is the thing drove me crazy before)
On your client computer use the same above procedure to open the
“Security Configuration” setting, make sure you check “Network DTC
Access”, “Allow Inbound/Outbound” option, restart service and computer
if necessary.
On you SQL server service manager, click “Service” dropdown, select
“Distribute Transaction Coordinator”, it should be also running on
your server computer.
Hope it helps,

Reference URL

http://msdn.microsoft.com/en-us/library/aa561924%28v=bts.20%29.aspx

ASP.NET IIS Registration Tool – Aspnet_regiis.exe

When multiple versions of the .NET Framework are executing side-by-side on a single computer, the ASP.NET ISAPI version mapped to an ASP.NET application determines which version of the common language runtime (CLR) is used for the application. The ASP.NET IIS Registration Tool (Aspnet_regiis.exe) allows an administrator or installation program to easily update the script maps for an ASP.NET application to point to the ASP.NET ISAPI version that is associated with the tool. The tool can also be used to display the status of all installed versions of ASP. NET, register the ASP.NET version that is coupled with the tool, create client-script directories, and perform other configuration operations.

Problem Situation
I have faced one problem while deploying the website.
Actually I need to deploy a website on my computer where all the ASP.Net Framework are installed like 2.0, 3.5 and 4.0
After that I have installed the IIS on computer properly and I have deployed my website
My website is not working because my all the framework are not registered with my IIS Server. This is because my frameworks are installed before the IIS installation that why it is not registered with IIS server
Then I have to registered framework with IIS Server with the help of ASP.NET IIS Registration Tool (Aspnet_regiis.exe)
Reference URL: http://msdn.microsoft.com/en-us/library/k6h9cz8h(v=vs.80).aspx