Anybody know about alternative solution to avoid cursor. It will very helpful to me.
I have 2 tables (Table A & Table B).I wish to read one by one records from Table A and compare with Table B. Currently we have use cursor for this purpose. But the SQL Server is waiting on the I/O to complete after a Log block in cache is flushed from Memory to Disk.