Monthly Archive:: December 2013

17 Dec 2013

Brain Teaser Series – The Chocolate Shop!!

Everyone loves candies and chocolate. It’s even more fun when you can some free ones. Here is puzzle for you. A candy shop sells a chocolate for $1 each and for every 3 empty wrappers gives one
6 Dec 2013

Exuberant India – Visit Mussoorie (Fun Retreat in a Hillstation Close to Delhi)

Mussoorie, Queen of the Hills, located some 290 km north of New Delhi, is among the most popular hill stations of the country. At 6500 feet elevation, it has some of the most spectacular views of Himalayas.
2 Dec 2013

Rebuild all index in a database

Several times my colleagues asked me about rebuilding all indices in a database. While there are several solution available, I like to use the one below. Please note that sp_MSforeachtable is undocumented but internal so we can