Categories
Database Development

How to avoid tempdb spill

I have several tempdb spills in queries which are currently serving business purposes. I am told by online searching that tempdb spills should never be ignored as they can cause performance problems. It’s still a bit unclear to me as to why that is. Since I have also read that SQL Server by itself will […]

Categories
Development

how to stop infinite loop when there is no more data (pagination)

I need help with this jquery script I’m using in my pagination to create lazy loading/ infinite scroll. The loading is working, however, it keeps displaying 1 whenever new data is loaded and at the end if there is no more data it keeps load 1 1 1 1 infinitely. I need help in getting […]

Categories
Development

jqGrid getRowData doesn’t return the current set of values

i’m implementing the copy functionality in jqGrid in inline edit mode. On clicking the copy icon for a row the contents of the row will be added as new row. On clicking copy the new row gets created but the copied data in cell is not the current data that is entered in the row. […]