we have already 3-4 virtual servers in same hardware. but it takes the load perfectly without too much delay.

Only Report upload and access configurations earlier was around 5 seconds now...

Hello,

Hope no need to delete the thread but they are suggest to ask help for problems happened in work rather than ask for answers for interview questions.

google is best help...

mirroring is uses for more database availability time, if your first server crash second should...

i completely agree with Gianluca Sartori

we have to include a trigger for proper action on all tables.

Hello,

What are ther main reasons for log file growth.

IN my case we take only full back up daily, no log backup.

doesnt seams to be shriniking after backup.

thanks for the suggestion one more doubt will this impact data files any how?

but it is working in sql 2005...

use testdb

dump tran testdb with no_log

dbcc shrinkfile (testdb_log,truncateonly)

will this truncate also a bad idea if its regular or irregular..

suggestions pls.

check whether dataset parameter mapping is done properly.

if you share how you have done it will let you know the issue.

how can i embed the macro embedded excel while exporting.

Hello,

can i get help on this?

hope you have to do this in query

kindly clarify

1. Is Mr Smith's old designation was Maanger and now he is a CEO? if not how 2 dsignations.

2. do you want the data in 2 lines.

Hello,

Hope report has some issue, kindly run the report in BI with same parameters and check.

Hello,

this is in report layout not in dataset.

hello,

thsi is what i am using

"=IIF(IsNumeric(Fields!units.Value), Formatpercent(Fields!units.Value / Fields!Total.Value,2 ), Formatpercent(0,2 ))"

hope formatpercent cannot be converted to decimal.

kindly help