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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / d. shyamala

Answers were Sorted based on User's Feedback



I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / prasad

Im giving few suggestions known to me.

- Update table statistics regularly.
- ur log might be full. clear the log using dump tran with
no_log
- if u r connecting ur server in a network, check the
network connections.

Is This Answer Correct ?    4 Yes 1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / arun sql gamer

Might be a performance tuning problem.Previously it may
have less data ,since it wont give u that much trouble in
processing the query.Subsequently the size of the data may
get increased which leads to more processing time of query
hence forth arrive with the problem of tuning and to check
for proper indexing in table and also in query.

Is This Answer Correct ?    3 Yes 1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / monal

Update table statistics.

Is This Answer Correct ?    0 Yes 1 No

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every d..

Answer / jerry joseph

Number of hits might have increased..

you can try increasing the timeout

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the purpose of the tempdb database?

0 Answers  

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

what is a transaction? : Sql server database administration

0 Answers  

What stored by the master?

0 Answers  

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

What is the difference between TRUNCATE and DROP?

0 Answers  

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

What are different types of constraints?

0 Answers  

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

can any one please send sql quries most used in applications.

2 Answers  

For more SQL Server Interview Questions Click Here
Categories