http://www.sqlservercentral.com/Articles tagged Miscellaneous, Indexing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit! http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/2005/03/04http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search. http://www.sqlservercentral.com/articles/Miscellaneous/20010422025723/74/2003/09/25http://www.sqlservercentral.com/articles/Miscellaneous/20010422025723/74/Integrate high performance index- and search functionality in your SQL database. Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed) http://www.sqlservercentral.com/redirect/articles/1009/2003/06/10http://www.sqlservercentral.com/redirect/articles/1009/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table. http://www.sqlservercentral.com/articles/Performance+Tuning/clusterthatindex/952/2003/03/30http://www.sqlservercentral.com/articles/Performance+Tuning/clusterthatindex/952/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles! http://www.sqlservercentral.com/articles/Administering/maintenanceplansbehindthescenes/693/2002/05/27http://www.sqlservercentral.com/articles/Administering/maintenanceplansbehindthescenes/693/In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all! http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplansunderthecovers/686/2002/05/21http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplansunderthecovers/686/This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks! http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reviewofsqlserver2000performancetuning/673/2002/05/03http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reviewofsqlserver2000performancetuning/673/Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit! http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/2005/03/04http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/