also, u can right click on server, reports-- standard reports

and then see the --Top queries by average CPU time...and other more information.

Regards,

Sushant

I dont understand why people ask interview questions here,

when they know that they can get many links on google.

Also, if somebody replies to interview questions, their links would also...

I cant find how to change the hierarchy of that column to monthwise in hte cube.

Regards

Sushant

Any thoughts.

Regards,

Sushant

Wat abt maintanence plans running under user 'sa'?

Regards,

Sushant

lol....:)

@ bucket

Are you trying to tell me to change the underlying table in prod database or

from the excel file itself

or inside the cube

from where can i change tht??

Thanks.

Regards,

Sushant

but the size of backup cant be determined by the so called allocated space for the db.

Regards,

Sushant

thts difffernet from wat i said...

I said hte approx backup size and u told abt hte total size of the db.

Regards,

Sushant

I dont know, if iam right, but i do this...

GO to database-->right click -->tasks--> shrink--> files-->

see the avalaible free space( %)

100 -( %) = % of the currently...

You mean a trigger??

But, wats wrong in seeign hte default trace for data changes, i cant get tht.

Regards,

Sushant

@ gail..

Then wats the alternative?

Regards,

Sushant

@ lowell

Thxs for replying.

I did not get what u replied..

I have around 16k rows wid different items ..

I cant know, how can i apply ur solution to my table.

Regards,

Sushant

For a particular item and a particular date_sold , there can be max of 1 row and a minimum of 0 rows (if pricedate> date_sold)

Regards,

Sushant

yes the column is not unique but is a primary key..

what should i do?

Regards,

Sushant