snowfrost.c (6/6/2014)
Hi All ,I am using MS SQL Server 2005 as my database. Previously I have some issues with my table indexes and the retrieval of my select is abit slow. If I drop and re-create the indexes, the select statement is fast.
Thus I have scheduled a job to drop and re-create my index weekly but it doesn't to work well. After 4 days, the select statement is slow again and I have to drop and re-create.
Anyone encountered this issue before and any solution is appreciated.
Thank You.
You drop and recreate your indexes weekly??? Have you checked the fragmentation? You should read this article. http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/