All Questions
3
questions
3
votes
1
answer
1k
views
Daily SQL job to delete records older than 24 hours
Below is a delete job to delete 1M+ records daily and takes 13 hours to complete and sometimes more than that. I need to optimize this.
The table tblcalldatastore is being inserted 24*7 through a ...
1
vote
1
answer
105
views
Delete duplicate entries with lower IDs
I have a function that deletes duplicate entries. The highest ID is kept and the older ones are removed.
function:
...
1
vote
2
answers
92
views
Store procedure timing out sometimes
Can someone please find out why this store procedure is timing out?
...