Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
panneer36
Starting Member
2 Posts |
 Posted - 2012-04-27 : 07:04:48
|
| Hi Friends,I have problem with my database.I have 10 years record in my Database.till year 2011 i did not face any slow execution.from 2012 whenever i fetch current year(2012) data the execution time delayed.what i need to do in my database.Please give me your suggestions please. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-04-27 : 07:35:55
|
Rebuild indexes, update statistics.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
panneer36
Starting Member
2 Posts |
Posted - 2012-04-27 : 07:42:49
|
| Thanks but thing is when i have used date on where condition.. it takes too time for execution. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-04-27 : 09:01:06
|
Rebuild indexes, update statistics.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-28 : 07:38:07
|
| Yup. Its as Sweposo says.Rebuild indexes, update statistics.N 28° 33' 11.93148"E 77° 14' 33.66384" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-28 : 19:24:47
|
quote:
Originally posted by vinu.vijayan
Yup. Its as Sweposo says.Rebuild indexes, update statistics.N 28° 33' 11.93148"E 77° 14' 33.66384"
is it an echo service?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-29 : 10:36:50
|
| Execution plans can show you detailed information - confirm the requirement outlined aboveJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Slow Execution for 2012 records