Forum Replies Created

Viewing 15 posts - 46 through 60 (of 177 total)

  • RE: Parallel Processing

    [p]Scott was exactly right. The OUTPUT clause of the UPDATE allows us to get data back from the inserted and deleted tables (the same as we reference in DML triggers)....

  • RE: Parallel Processing

    I recently (within the last 2 years) created a system to monitor our SQL instances from a central instance. Without going into details about the whole process, I had a...

  • RE: SSAS And Oracle - Can't connect to the data source

    It was apparently a known bug in the Oracle driver - both BIDS and SSMS are 32-bit apps and need the 32-bit client, but the 32-bit client can't handle special...

  • RE: Transaction log shipping + Size of Transaction log file

    INDEXDEFRAG should create less log growth than REINDEX, however, if the growth is still excessive, you may have to come up with a different Log-Shipping strategy.

    (1) You can switch to...

  • RE: Real time replication to datawarehouse

    Transactional Replication doesnt allow for transformations, so it wont work as a single solution.

    Have you thought about a third-party product to do the data movement, such as Informatica /...

  • RE: Why so many reads?

    D'oh - missed seeing the "PK_" in the list.

  • RE: Why so many reads?

    Is IX_ptLabResults_UniqueRecord the clustered index?

  • RE: Why so many reads?

    :blink: that's a very wide table. What indexes are defined on the table?

    And, why the IF (SELECT count(*) FROM sys.tables WHERE name = 'ptLabResults') > 0? It's been quite...

  • RE: VarChar(max)?!?

    I thought the explanation was really lacking something ... like explaining

    The REPLICATE function only returns 8000 characters (defaults to VARCHAR(8000)) if the character value to be replicated isn't explicitly CAST...

  • RE: Issues with 400TB Database

    Michael Valentine Jones (8/5/2008)


    Are you really sure about the size of this database? Maybe it is really 400 GB?

    400 TB would make it one of the world’s largest databases...

  • RE: what disk type should i use

    NP. Sorry I can't give you a defintive answer on performance gains.

    I don't tend to revisit older systems to reformat disks - business units dont have much appetite for...

  • RE: what disk type should i use

    That depends on several things - the size of the database vs the amount of RAM, I/O profile of the database, number of updates in the database, etc. I have...

  • RE: Problems posting forum replies

    Actually, it's DangerMouse ... http://www.chf.co.uk/shows/past/dangermouse/. :smooooth:

    And, I just realised - 'Reply' worked this time ... go figure :crazy:

  • RE: Stored Procedure Review

    GilaMonster (7/24/2008)


    Sandy (7/23/2008)


    Simon,

    but how you identify this?....;)

    To get out of a while loop, there must be a statement within the loop that sets the variable involved in the while condition...

  • RE: Stored Procedure Review

    david.sims (7/23/2008)


    ...

    ...

    while @TotalBilled is not null

    begin

    update projectcustomtabfields

    set custJTDBilled =@TotalBilled

    where wbs1 = CAST(@projnum AS char(6)) and wbs2=''

    end

    ...

    This loop is never going to quit - the value for @TotalBilled never changes...

Viewing 15 posts - 46 through 60 (of 177 total)