November 12, 2013 at 11:53 am
I'm working with a database that has some performance prolems. We have determined that some indexes need to be implemented to improve this.
I have the indexes scripted and I'm ready to apply them. I'm doing them in groups, not all at once, just in case...
My question is, are there any best practices for implementing these? Should I reindex before/after? Update Stats? etc?
November 12, 2013 at 11:57 am
This is a mighty big topic. I would start by looking here. http://www.sqlservercentral.com/stairway/72399/[/url]
_______________________________________________________________
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/
November 12, 2013 at 1:10 pm
Just run the create index statements, not much more to it than that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2013 at 7:08 am
K Currie (11/12/2013)
Should I reindex before/after? Update Stats? etc?
Here is the link http://www.mssqltips.com/sql-server-tip-category/38/indexing/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply