Sun 30 May 2010

Query to find all the Tables and Index with number of days statistics being old. Then run Update Statistics command to update statictics for optimized query plan.

OBJECT_NAME(A.object_id) AS Object_Name, AS index_name,
STATS_DATE(A.OBJECT_ID, index_id) AS StatsUpdated ,
getdate()) DaysOld
FROM sys.indexes A
INNER JOIN sys.tables B ON A.object_id = B.object_id


Comments here
Sun 28 Dec 2008

Cool rebranding due to financial crisis... 3m, apple, cisco, citigroup, dell, ferrari, ford, goodyear, jones, lg, nike, nokia, xerox, yahoo....


rebrand 3m.jpg

rebrand apple.jpg

rebrand buy.jpg

rebrand cisco.jpg

rebrand citi.jpg

rebrand dell.jpg

rebrand ferrari.jpg

rebrand ford.jpg

rebrand goodyear.jpg

rebrand jones.jpg

rebrand lg.jpg

rebrand nike.jpg

rebrand nokia.jpg

rebrand ssler.jpg

rebrand xerox.jpg

rebrand yahoo.jpg

Categories : Pics / Images Shot
Comments here
Tue 7 Oct 2008

If You Think Fuel is the Only Liquid That is really expensive!!!

When you fill up car's fuel tank, you think that fuel has become really expensive after the recent price hike.
Let's compared it with other common liquids and do some quick calculations, and you will feel a little better To know why,
see the results below you'll be surprised at how outrageous some other prices are:

Diesel (regular)                                           : Rs.65 per litre

Petrol (speed)                                             : Rs.86 per litre

Coca Cola 330 ml can                                   : Rs.20 = Rs.61 per litre

Dettol antiseptic 100 ml                                  : Rs.20 = Rs.200 per litre

Radiator coolant 500 ml                                  : Rs.160 = Rs.320 per litre

Pantene conditioner 400 ml                                    : Rs.165 = Rs.413 per litre

Medicinal Mouthwash like Listerine 100 ml     : Rs.45 = Rs.450 per litre

Red Bull 150 ml can                                                      : Rs.75 = Rs.500 per litre

Corex cough syrup 100 ml                                         : Rs.57 = Rs.570 per liter

Kores whiteout 15 ml                                                   : Rs.15 = Rs. 1,000 per liter

Cup of coffee at any decent business hotel 100 ml for            : Rs. 50 = Rs. 500  per liter

Old Spice after shave lotion 100 ml                     : Rs. 175 = Rs. 1750 per litre

Pure almond oil 25 ml                                                  : Rs. 68 = Rs.2,720 per liter

And this is the REAL KICKER...

HP DeskJet colour ink cartridge 21 ml                : Rs.1,900 = Rs.90,476 per liter!!!

Now you know why computer printers are so cheap? So they have you hooked for the ink!

So, the next time you're at the pump, don't curse anyone just be glad your car doesn't run on cough syrup, after shave, coffee, or God forbid, Printer ink!


Categories : Knowledge / Amazing
Comments here
Thu 31 Jul 2008
Categories : Pics / Images Shot
Comments (1)
Thu 10 Jul 2008
Categories : Pics / Images Shot
Comments here
Wed 28 May 2008

sadqa jab apne malik k hath se nikalta hai to us waqt 5 jumlay kehta hai

1> main fani maal tha tu ne mujhe baqa di

2> mein tera dushman tha ab tu ne mujhe dost bana lia

3> aj se pehle tu meri hifazat karta tha ab main teri hifazat karounga

4> main haqeer tha tu ne mujhe azeem bana dia

5> pehle main tere hath main tha ab main khuda k hath main hoon

Comments (2)
Sat 21 Jul 2007

Top 10

  • Best selling cars
  • Biggest athletes
  • Biggest alcohol consumption
  • Cleanest countries
  • Coffee drinking nation
  • Countries with highest suicide rates
  • Countries with highest divorce rates
  • Countries with greatest populations
  • Countries with with most airports
  • Countries with births per year
  • Countries with most billioners
  • Countries with most number of cows
  • Deepest oceans and seas
  • Highest death rates in world
  • The fastest cars in world
  • Highest house hold size
  • Lowest average birth weights
  • Biggest car production
  • Most common causes of accidental death
  • Countries with highest life expectancy
  • Largest countries in world.

Categories : Knowledge / Amazing
Comments (1)