Re: Adding Hints to the SQL for processing cubes?

Tech-Archive recommends: Fix windows errors by optimizing your registry

As I know, there is no way to add hint.

I guess you have to turn off parallelism of SQL Server.

Ohjoo

"William Lipp" <w.b.(MyLastNameHere)@ieee.org> wrote in message
news:pvrtq2p8p7bniee0siri1ss84vn49blgug@xxxxxxxxxx
When I process a cube, an SQL query gets run - I can see that query
using Profile Analyzer on the SQL database. I have a nightly process
that is failing 2 or 3 times per month because of "internal deadlock."
If it was direct SQL, I would fix it by adding the hint OPTION(MAXDOP
1); to the query.

Is there any way to get the hint added to the query that runs when
processing a partition? SQL 2000. Thanks.

William


.

Relevant Pages

  • Re: SQL statement inquiry **brain-blocked here** :o(
    ... Can you post the SQL of the query that is not working for you? ... (HINT, Select View: SQL from the menu) ... output list the UPC and DEPT for that particular store. ...
    (microsoft.public.access.queries)
  • Re: Forcing index usage...
    ... I'm in a situation where oracle spatial doesn't use a domain index even if I use the index hint. ... But as soon as I add more predicates or nest the query into another one, ... Could you give us an example of the SQL ... Complete with execution plans. ...
    (comp.databases.oracle.server)
  • Adding Hints to the SQL for processing cubes?
    ... an SQL query gets run - I can see that query ... I have a nightly process ... I would fix it by adding the hint OPTION(MAXDOP ...
    (microsoft.public.sqlserver.olap)
  • Re: Date Query
    ... it's a hint at the SQL of a Query. ... Count, Sum, Average, and so on. ...
    (microsoft.public.access.queries)
  • Re: Adding Hints to the SQL for processing cubes?
    ... I have a nightly process ... If it was direct SQL, I would fix it by adding the hint OPTION(MAXDOP ... 1); to the query. ...
    (microsoft.public.sqlserver.olap)