1
Answer

Big Data or any other technology for .Net Developers

Ankur Agarwal

Ankur Agarwal

9y
561
1
Hi Mahesh,
 
I am working on .Net from past 7 years but don't know why not getting the satisfaction in terms of level of work and compensation , would be great if you can suggest me something , should i explore the Big data world and  if yes and what is path for a .Net developer to move to Big data .
 
i will be very thankful to you 
Answers (1)
1
Madhanmohan Devarajan

Madhanmohan Devarajan

NA 6.5k 471.5k 8y
Gaurav,
Would like to understand few things.
Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.
Below link has the sample stored procedure to delete the records (result of search query) from the table.
https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx
Hope it will solve your issue.
Accepted
0
Nigel Fernandes

Nigel Fernandes

NA 4k 138.9k 8y
Another approach you can take is schedule the deletion of rows during a time when database is not used.
Example during Night.
Then you would not need to implement any extra logic.
But use this, only if deletion can be done later.
0
Nepethya Rana

Nepethya Rana

NA 335 20.1k 8y
CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO
0
Dhananjay Kumar

Dhananjay Kumar

NA 1.1k 8.7k 8y
https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes