Re: What's wrong ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 07/26/04

  • Next message: Bart Torbert: "Re: Size of SQLServer databases with indices"
    Date: Mon, 26 Jul 2004 13:29:49 +0100
    
    

    > If you want more info like CREATE TABLE / INSERT TABLE so you
    > can copy / paste to your QA and try I'll post them.

    It would help. Your query is syntactically valid so the problem is in your
    logic and/or your data.

    -- 
    David Portas
    SQL Server MVP
    --
    

  • Next message: Bart Torbert: "Re: Size of SQLServer databases with indices"

    Relevant Pages

    • Re: SQL 2000, SP3a "TOP 100%"
      ... The best place to use ORDER BY is when you query the view. ... David Portas ... SQL Server MVP ... Prev by Date: ...
      (microsoft.public.sqlserver)
    • Re: sp3 in sql 2000
      ... Thank's 4 ur attention David Portas. ... BEFORE INSTALLED service pack 2/3, this query result: ... > SQL Server MVP ...
      (microsoft.public.sqlserver.server)
    • setting in server sql2000
      ... Thank's 4 ur attention David Portas. ... BEFORE INSTALLED service pack 2/3, this query result: ... > SQL Server MVP ...
      (microsoft.public.sqlserver.server)
    • Re: Adding lines to a table base on a Quanitity
      ... I suspect that's not what you *need*. ... The best starting point when writing a query ... David Portas ... SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Re: FTS Performance in SQL 2005
      ... Can you post you query plans and the output of statistics IO ... SQL Server MVP ... Because i've set the MAX sql-server memory to 3.5 GB instead of 4.0 GB ... cost relative to the whole batch, ...
      (microsoft.public.sqlserver.fulltext)