MS SQL reindexing Database

You guys might be already know this:

Script to automatically reindex all tables in a database. Please note that this might take up to 12 hours. I run this on my database and took 4 hours. the database size was 21 G. You also need (size of your db * 2) free space to run this…

USE Databasename

DECLARE . . . → Read More: MS SQL reindexing Database

Bible Compared to Quran

I thought I would share this article with you… Credit: http://www.islamtomorrow.com/articles/Bible_vs_Quran.asp

Bible Compared to Quran
Based on transcripts of vairous lectures given by Yusuf Estes & Dr. Gary Miller

Introduction by Yusuf Estes -
It should be stated at the outset of this work, that Muslims do not seek to put down or desecrete the Holy Bible. It is a matter critical matter of faith for Muslims to believe in the original revelations that came down to Moses, David, Solomon and Jesus, just as it is is important for Muslims to believe in the revelation of the Quran that came to Muhammad, peace be upon him. The key word here however, is “original.” As we all know the origin of the Bible is clouded with centuries of copying, translating and passing down information, now long lost with only copies of manuscripts remaining to remind us of what once was the Bible.

Additionally, it should be noted that Muslims do not seek to destroy the Christians or Jews belief in the Word of God, rather it is an obligation for Muslims to call to what is right and to halt that which is evil. Certainly, causing the “People of the Book” (as the Quran refers to Christians and Jews) to fall into disbelief and leave off any faith in God at all, is the very opposite of the direction Muslims should take in presenting any comparison between Islam and what has come down in the past from the Almighty God. We only seek to bring about more light to the people seeking guidance and pray for all of us to be successful with our Lord in this life and in the Next life and we ask His Guidance and Support in doing so, ameen.

Continue reading Bible Compared to Quran


Protected: Heeva

There is no excerpt because this is a protected post.

SQL breakdown TIME

This statement will count number of records in a given month and breakdown it every 30 minutes.

select count(ID) as ID_Count, Date_30min from
( select ID, convert(datetime,convert(varchar(14),calldatetimefield,120) + case when datepart(minute,calldatetimefield) < 30 then ‘00′ else ‘30′ end) as date_30min
from tablename where calldatetimefield between ‘2009-02-01 00:00:00.000′ and ‘2009-02-28 23:59:59.997′ and ……) . . . → Read More: SQL breakdown TIME

Molood in peshvar

I have also found this on youtube. I missed all this . . . → Read More: Molood in peshvar

SQL updating field with current timestamp

MS SQL to update a field to current time:

update tbl1 set col1 = convert(varchar(5),getdate() ,108)

result:

col1 . . . → Read More: SQL updating field with current timestamp

Peshvaries in 1957

I got these two pictures from someone in Bahrain…. I have no idea who these people are.. the picture was taken in 1957…

if you do please let . . . → Read More: Peshvaries in 1957

Pay Zakaat, Sadagha, donation and etc Online

I recently came across this site:

Khaire Online

you can pay Zakat, Vaghfeyat, Sadagha and more donations online… You can also choose the country that you would like to send your donation to.

The site in based in Kuwait. KNET is the only option that they accept for online payment. Visit their web site for more . . . → Read More: Pay Zakaat, Sadagha, donation and etc Online

Peshvar Soccer team in Kuwait

Hi All,

Shabab Team

This is Shabab team in Kuwait. Apparently they are doing pretty good. Just to avoid any copyright, I got the picture . . . → Read More: Peshvar Soccer team in Kuwait

Wedding - Aroosi Peshvar

I just found this video on youtube
Funny, I was . . . → Read More: Wedding - Aroosi Peshvar