Only one clustered index can be created on table

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

To create a different clustered index on the same table, change the Create as Clustered property setting on the existing clustered index before creating the second index.

For all your application development needs, visit for a fiscally conscious proposal that meets your needs ( So I can keep this blog going as well!!!!)

Alternatively click through the link   if you found this article interesting. (This will help the companies Search engine rankings)


such is life

Patti Page Young:

Patti Page Old:,r:12,s:0,i:128



Got to move away from wordpress as well… I guess… Tumbler here I come.

An ode to st. Chantix

I have been smoking for about 12 years. For a long time I refused to believe that I was a smoker. What started as an idle past time with friends over a cup of coffee has effectively become the excuse for everything. Feeling good, bad, hungry…have a smoke. It even helps to alleviate a blocked nose.. well so it seems…until its too late. Under doctors orders (for medical reasons), I had to quit smoking. Enter Chantix…the one stop solution to nicotine addiction….well almost. For the record this was the third time I am on Chantix. The first two times were a phenomenal success. I stayed off it for three to four months and started it again…WHY??? I DON’T KNOW, BUT I DID.

The reason for this post is to warn smokers and the users of Chantix. The third time on Chantix was like a nightmare. The drug its was not working for me. The first two times, I hardly had the urge to smoke, but this time it did not have that effect. I was smoking well beyond the advertised 7 days. My heart was a mess. I couldn’t take seven steps without going through heavy heart palpitations. I had never experienced that before. Climbing steps was even worse. I would feel like I was going to faint. I seriously thought that my heart was giving up on me.

Fortunately I started goggling on Chantix and saw some web responses from others. I got off Chantix just 2 days back (after using it for 2 weeks) and I can already feel the difference. I feel so much better. At the end of the day, my advice is you have to WANT and NEED to quit. Nothing else works. Its been 2 days since I stopped Chantix, and the the urge to smoke is mind numbing, but I am not going back there ever again.


Life as it is

I have been meaning to blog for a while, but I have never gotten around to it. I had several other blogs before, some were fictitious, some were centered around my life, but eventually I had to take it down, because I thought they were in some ways self incriminating.

Anyways, I got up this morning and couldn’t go to sleep. Joge is studying for her exam so I thought I will give her company. My dream had always been to read the Bible and pray early in the morning, which I was able to do today.

My voice You shall hear in the morning, O Lord, In the morning I will direct it to You, And I will look up. (Psalm 5-3, NKJV)

Salvation begins and ends with God. I have been struggling with that statement since the first time I believed in God. I always tried to make myself right with God… but it never happened, because that never happened. It took me 25 years to get that simple statement.