Forum Replies Created

Viewing 15 posts - 42,661 through 42,675 (of 49,552 total)

  • RE: Aggregate function SUM gives some junk value

    santhoshkumar.boregowda (12/2/2008)

    The SUM of above must be equal to zero.

    No way to ensure that with a float.

    Any Suggestion?

    Change the data type to one that is precise and accurate.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 2:07 pm

    #906499

  • RE: Aggregate function SUM gives some junk value

    santhoshkumar.boregowda (12/2/2008)

    Thanks Gila,

    Actually these types of result are affecting the production in one or other way.

    some batches will be having a query like

    WHERE col = '0'...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 2:05 pm

    #906498

  • RE: Aggregate function SUM gives some junk value

    You're not getting a junk value, you're getting a value very close to 0. -2.7465348468E-13 is scientific notation. Expanded out it's 0.000000000000227373675443232

    Float's aren't accurate data types. They're approximate and rounding...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 1:20 pm

    #906480

  • RE: Production issue

    As I said, firstly, the growth should not be 10%. That's a bad default and it gets out of hand on larger databases. Change it to a fixed size (depending...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 1:16 pm

    #906477

  • RE: Recommended path for advanced training?

    jeffkretz (12/2/2008)

    Does anyone have any opionions about this practice? Good idea? Bad idea?

    JK

    I think a lot of people do that or do a full technical interview before the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 1:12 pm

    #906474

  • RE: Any sql-db-related objects updated?

    Grant Fritchey (12/2/2008)

    , OK, changing data can change statistics, so where the statistics are maintained can be changed, and if you have indexes on the columns that you modified or...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 1:01 pm

    #906467

  • RE: Production issue

    Two things.

    Autogrow should not be left on a percentage (the default) as that causes massive grows for larger databases, with the resulting time problems and poor performance during the grow.

    You...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 12:59 pm

    #906465

  • RE: Ambiguous field name error

    You could. I had this nasty mess on my hands once on SQL 2000.

    SELECT SomeColumn, CONVERT(varchar(20),SomeDate,107) AS SomeDate

    FRom SomeTable

    Order By SomeDate

    The ordering came out with April first.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 11:41 am

    #906426

  • RE: Shrink job failed with Error 644 (could not find index entry)..

    Paul Randal (12/2/2008)

    Hmm - I don't think the corruption was in the nonclustered indexes - I think the corruption was (and still is) in the base table itself.

    Of course,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 11:29 am

    #906420

  • RE: Integrity Check -- DBCC

    Could you post the complete output of checkDB please, with all of its errors and recomendations.

    Was this DB upgraded from SQL 2000 and how long ago was it upgraded?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 11:09 am

    #906399

  • RE: Ambiguous field name error

    Grant Fritchey (12/2/2008)

    Clarification: "Column aliases in ORDER BY clause cannot be prefixed by table alias"

    Sorry. What I said earlier was misleading. Also, on rereading, I'm not shocked that this doesn't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 10:47 am

    #906382

  • RE: Data File Spilit accross various Drives. One is running out of space.

    scb (12/2/2008)

    Say for instance that you have one particular table that is huge and filling that drive. Say it's referenced by 5 stored procedures. Assuming there are minimal...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 10:40 am

    #906377

  • RE: Are the posted questions getting worse?

    Chris Morris (12/2/2008)

    What is it about DBA's wanting to look like Darth Vader? 😛

    I have no idea...

    I just have him as my cell phone ring tone...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 10:31 am

    #906363

  • RE: how to configure sql server memory

    No. 3gb and AWE are for 32 bit only.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 10:30 am

    #906362

  • RE: Basic Optimum Performance setup

    Shark Energy (12/2/2008)

    EDIT: If going with this plan, which array would I be best sticking backups on?

    A separate one. Backups onto the same array as data is firstly an eggs...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2008 at 10:05 am

    #906345

Viewing 15 posts - 42,661 through 42,675 (of 49,552 total)