---
title: "more SQL optimization resources and a bonus tip"
url: "https://osherove.com/blog/2003/12/28/more-sql-optimization-resources-and-a-bonus-tip.md"
canonical: "https://osherove.com/blog/2003/12/28/more-sql-optimization-resources-and-a-bonus-tip.html"
published: "2003-12-28T23:25:00"
updated: "2003-12-28T23:25:00"
tags: [".Net Quotations", "Cool Articles"]
author: "Roy Osherove"
description: "Michal suggests a few more SQL optimization links in return for my optimization experience : sql-server-performance.com SQL Server 2000 Performance Tuning Tools Performance Category on SQLTeam.com Performance Tuning…"
usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)."
license: "https://creativecommons.org/licenses/by/4.0/"
---

# more SQL optimization resources and a bonus tip

By Roy Osherove December 28, 2003 In [.Net Quotations](https://osherove.com/blog/category/net-quotations), [Cool Articles](https://osherove.com/blog/category/cool-articles)

**Historical article** · Originally published December 28, 2003; technical details may be outdated.

[Michal suggests a few more](http://blog.vyvojar.cz/michal/posts/383.aspx) SQL optimization links in return for my [optimization experience](http://weblogs.asp.net/rosherove/articles/OptimizingExperience.aspx):

- [sql-server-performance.com](http://www.sql-server-performance.com/)
- [SQL Server 2000 Performance Tuning Tools](http://www.sqlteam.com/item.asp?ItemID=761)
- [Performance Category on SQLTeam.com](http://www.sqlteam.com/FilterTopics.asp?TopicID=103)
- [Performance Tuning articles on SSWUG.ORG](http://www.sswug.org/searchresults.asp?keywordstofind2=performance%20tuning)
- [SQL Server Center](http://www.sswug.org/centersql), [Oracle Center](http://www.sswug.org/centeroracle), [DB2 Center](http://www.sswug.org/centerdb2) - SSWUG.ORG (SQL Server Worldwide User's Group), [SSWUG RSS](http://web2rss.vyvojar.cz/rss/283.xml) via [WEB2RSS](http://web2rss.vyvojar.cz/)

Also, [Kyls](http://kylecordes.com/) writes:

_"I wish there was an option to tell SQL Server "No matter what, never table scan a table with more than a million rows; if you come up with a plan that does that, punt and throw an error message instead, so a DBA can fix it, rather than pound on a production database for 10 minutes straight"_

to which [Darrel](http://dotnetjunkies.com/weblog/darrell.norton/) Responds:

_"Kyle, there is something similar to what you are asking for. Check out the Query Governor Cost Limit Option for SQL Server configuration: (_[_http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad\_config\_73u6.asp_](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_73u6.asp)_)._ "

## More in .Net Quotations

[All posts in .Net Quotations](https://osherove.com/blog/category/net-quotations)

- Dec 31, 2003

    ### [Jan does cool stuff: nice article and cool extension to the winform data grid](https://osherove.com/blog/2003/12/31/jan-does-cool-stuff-nice-article-and-cool-extension-to-the-w.html)

- Dec 29, 2003

    ### [Risk Management](https://osherove.com/blog/2003/12/29/risk-management.html)

- Dec 27, 2003

    ### [New year's Nant, pathetic geek style](https://osherove.com/blog/2003/12/27/new-years-nant-pathetic-geek-style.html)

- Dec 24, 2003

    ### [Good stuff: New book, Remoting for imbeciles,CodeSmith 2.5 RC1, and OMG 0.2](https://osherove.com/blog/2003/12/24/good-stuff-new-book-remoting-for-imbecilescodesmith-25-rc1-a.html)


---

## About the author

**Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery.

### Sites

- [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership.
- [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts.
- [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin.
- [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model.
- [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps.
- [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes).

### Social

- X: https://x.com/royosherove
- LinkedIn: https://www.linkedin.com/in/osherove/

### Contact

- Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7

### License

Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/