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.

SELECT
OBJECT_NAME(A.object_id) AS Object_Name,
A.name AS index_name,
STATS_DATE(A.OBJECT_ID, index_id) AS StatsUpdated ,
DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id),
getdate()) DaysOld
FROM sys.indexes A
INNER JOIN sys.tables B ON A.object_id = B.object_id
WHERE A.name IS NOT NULL
ORDER BY DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id),getdate()) DESC

 

E-mail this post to someone or 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
E-mail this post to someone or 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

E-mail this post to someone or 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
E-mail this post to someone or Comments (1)