Viewing 15 posts - 766 through 780 (of 789 total)
OK ... now works ... and now I will see how time it takes!
thank you very much!
Dugi
March 28, 2008 at 8:19 am
:crying:
Still same problem:
Msg 156, Level 15, State 1, Procedure spHugeTable_IncrementalUpdate, Line 6
Incorrect syntax near the keyword 'TOP'.
March 28, 2008 at 8:05 am
rbarryyoung (3/28/2008)
Dugi (3/28/2008)
March 28, 2008 at 7:58 am
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...
March 28, 2008 at 7:51 am
rbarryyoung (3/27/2008)
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...
March 28, 2008 at 7:20 am
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:
March 28, 2008 at 6:30 am
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...
March 27, 2008 at 1:52 pm
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!...
March 27, 2008 at 1:14 pm
The explain link is wrong, it tells about "Application Roles"
:hehe::P
March 27, 2008 at 9:08 am
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...
March 20, 2008 at 8:03 am
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...
March 18, 2008 at 7:31 am
Hi,
Works very nice and ...counting the table with million records!
Thnx!
February 6, 2008 at 3:59 am
Viewing 15 posts - 766 through 780 (of 789 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy