Forum Replies Created

Viewing 15 posts - 766 through 780 (of 789 total)

  • RE: Huge table update

    OK ... now works ... and now I will see how time it takes!

    thank you very much!

    Dugi

  • RE: Huge table update

    :crying:

    Still same problem:

    Msg 156, Level 15, State 1, Procedure spHugeTable_IncrementalUpdate, Line 6

    Incorrect syntax near the keyword 'TOP'.

  • RE: Huge table update

    rbarryyoung (3/28/2008)


    Dugi (3/28/2008)


    I have the table with over 1 500 000 records and I want to update this table just in one column and I will write the original code...

  • RE: Huge table update

    Antares686:

    Thnx for fast reply but this is very simple what you wrote here, ok suggestion for the Left(NR_KEK,2) ... thank you so much ...

    but the SP is doesn't look like...

  • RE: Huge table update

    rbarryyoung (3/27/2008)


    Something to get you started:

    CREATE Procedure spHugeTable_IncrementalUpdate( @RowsPerBatch int )

    AS

    Update HugeTable

    Top (@RowsPerBatch)

    Set {columns to change, ...}

    , UpdateCol = 1

    Where UpdateCol=0

    Now write a SQL Job...

  • RE: Monitor Database Growth

    why the discussion is offline, since we are asking about any updates on this script!

    plz tell us someone ( do you find any alternative solution or not ?!)

    thnx!

    :w00t:

  • RE: How to hide the data

    thnx Steve for the little suggestion!

  • RE: How to hide the data

    hmm about store procedure it is not bad idea!

    I will try to write the script for that "sp" with parameters "@firstdate and @lastdate"

    and this is second solution as I...

  • RE: Managing the Storage

    I agree with you Steve ....hmmm I know that if I delete data I will win more space but these data is important!

    and no possible to change the HDD!...

  • RE: Encryption

    The explain link is wrong, it tells about "Application Roles"

    :hehe::P

  • RE: Who did what?

    very nice script...thnx!

  • RE: How to write SQL query to find a word in string"

    hello try this procedure maybe it helps you ...Cheers

    CREATE PROCEDURE SEARCH

    @SEARCH NVARCHAR(200)

    AS

    SELECT TOP 20 * FROM VIDEOS

    WHERE isEnabled=1 AND isPrivate=0

    AND (TITLE LIKE ('%' + @SEARCH% + '%') OR

    DESCRIPTION...

  • RE: How to test backup?

    on SQL server 2005 you have option during backup with GUI on Options "Perform checksum before writing to media" but how to see this Checksum number if you plane to...

  • RE: *=,=*

    hmm.. interesting info! Thnx!

  • RE: Get record count for a specific database

    Hi,

    Works very nice and ...counting the table with million records!

    Thnx!

Viewing 15 posts - 766 through 780 (of 789 total)