Hi,

i.e, Without two instance...Log shipping are not possible. I am right ?

Regards,

Sachin.

This is not true. I would like to learn with everyone. All are you important...

expect reply with someone...please help me.

expect answer from someone..kindly help me.

Hi Gail Shaw ,

Expect answer from your side.

Thanks in advance.

I can't ask from interviewer :

Why would you want more than one index on the same column?

Such type of question come in mind after interview.

Interviewer ask me simply how...

Hi Gail Shaw ,

Expect answer from your side.

Thanks in advance.

Hi,

How many nonclustered index we can implement on one column like "id" as per my below given table structure.

My table structure is : -

field ...

thanks a lot...

I know i am fresher....and i am giving interview......i have only 1 years of experience.

then what should i do....when any interviewer asking like such type of question ?

Should i left...

I think no...because clustered index only follow primay key.

Expect answer from other more.....

Actually In interview someone ask me, Suppose you have 6 TB Database in which you have so many tables (approx 70) but one table like "abc" contain more than 15...

There is no limit other than the availbale storage space.

-------------------------------------------------------

Hi,

Actually I have currently more than 10 lacs records in my table ok!!! In future within a year it will grow...

sp is using for generating report.....i am simply run my sp in query analyser

during the sp execution such type error comming.

My sp is more complicated and it's taking lot of...

Thanx for your reply..

Actually i am using sql server 2008....and using such thing for sp

Regards,

Sachin.