0

Please help me,I have a time & attendance application in ASP.net using SQL Server 2005 as database,The application was wornking very fine for thelast 5 years,suddenly last week,It is getting data for the first query,but for the second query it is taking long time and finally showing time out error

Recently my system Admin updated windows, dotnet & Sqlserver hotfixes

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
user2513019
  • 105
  • 1
  • 8

1 Answers1

2

Rebuild your indexes and statistics.

See here.

[Which version of SQL Server BTW?]

Community
  • 1
  • 1
Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
  • Thanks Mitch,I am using SQL server 2005,It creating a table using bulkcopy methode then that table is binding to a datalist after that i have some colour formating in the datalist say red colour for absent,coral & pink colour for weekenddays,then another colour scheme for leave days.Every thing working fine for the first two operation but if i am checking the next one,the application will take long time and time out error will throw,I check the database,the bulk copy is working fine,but iam getting the error in the binding of datalist..Thanks again – user2513019 Jun 23 '13 at 07:55
  • Thansk Mitch I rebuild all my index & stats,Now the application working fine...It was a great help from your side thanks again...! – user2513019 Jun 23 '13 at 08:13