Browse DevX
Sign up for e-mail newsletters from DevX

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