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

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 8:19 am

    #795208

  • 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'.

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 8:05 am

    #795196

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 7:58 am

    #795188

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 7:51 am

    #795183

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 7:20 am

    #795155

  • 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:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 28, 2008 at 6:30 am

    #795117

  • RE: How to hide the data

    thnx Steve for the little suggestion!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 27, 2008 at 3:26 pm

    #794895

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 27, 2008 at 1:52 pm

    #794843

  • 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!...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 27, 2008 at 1:14 pm

    #794818

  • RE: Encryption

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

    :hehe::P

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 27, 2008 at 9:08 am

    #794671

  • RE: Who did what?

    very nice script...thnx!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 25, 2008 at 7:06 am

    #793456

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 20, 2008 at 8:03 am

    #792010

  • 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...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 18, 2008 at 7:31 am

    #790802

  • RE: *=,=*

    hmm.. interesting info! Thnx!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    March 18, 2008 at 6:00 am

    #790752

  • RE: Get record count for a specific database

    Hi,

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

    Thnx!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    February 6, 2008 at 3:59 am

    #775508

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