Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Enterprise
Expertise: All
May 1, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Specify a Maximum Cost for a Query in SQL Server 7

Ever had a user accidentally create a query that resulted in a Cartesian product of your two largest tables? Of course, a badly written query uses up precious CPU and I/O cycles and therefore slows everyone down. With the advent of SQL Server 7, you can specify a maximum cost for a query. You can do this in two ways. First, set a maximum cost for all queries on your server by setting the configuration option "query governor cost limit" to the maximum number of seconds allowed for a query. (For those of you not familiar with the sp_configure command, this can be done through Enterprise Manager by right clicking on a Server, choosing Properties, clicking the Server setting tab, and choosing the "Use query governor
Joseph Lax
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date