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

thank you very much!

Dugi

:crying:

Still same problem:

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

Incorrect syntax near the keyword 'TOP'.

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

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

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

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:

thnx Steve for the little suggestion!

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

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

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

:hehe::P

very nice script...thnx!

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

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

hmm.. interesting info! Thnx!

Hi,

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

Thnx!