Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.

Answer Posted / monal

Update table statistics.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the query and subquery?

1060


Why should you use or avoid select * statements?

1002


What do you mean by authentication modes in sql server?

1065


What is an execution plan?

1120


What is the difference between inner join and equi join?

973


What is a fill factor?

1072


Difference between Logical Page and Physical Page in SSRS.

474


can you instantiate a com object by using t-sql? : Sql server database administration

982


What are click through reports?

142


how would you troubleshoot blocking? : Sql server database administration

967


What are the commands used in DCL?

1006


Which trace flags are enabled in sql server?

989


How to insert stored procedure result into temporary table?

1004


How to add code to the existing article (using improve article)?

1090


Explain the difference between functions and stored procedures in sql server?

963