Search Results

Search found 3 results on 1 pages for 'ronak'.

Page 1/1 | 1 

  • Is Query Performance different for different versions of SQL Server?

    - by Ronak Mathia
    I have fired 3 update queries in my stored procedure for 3 different tables. Each table contains almost 2,00,000 records and all records have to be updated. I am using indexing to speed up the performance. It quite working well with SQL Server 2008. stored procedure takes only 12 to 15 minutes to execute. (updates almost 1000 rows in 1 second in all three tables) But when I run same scenario with SQL Server 2008 R2 then stored procedure takes more time to complete execution. its about 55 to 60 minutes. (updates almost 100 rows in 1 second in all three tables). I couldn't find any reason or solution for that. I have also tested same scenario with SQL Server 2012. but result is same as above. Please give suggestions.

    Read the article

  • refresh page with ajax jquery without use of reload function

    - by Ronak Patel
    I am performing delete records by using jquery ajax in php. I want to refresh that content without the use of location.reload() function. I tried this, $("#divSettings").html(this); but, it's not working. What's the correct logic to get updated content in div. Thanks. Code: function deletePoll(postId){ $.ajax({ type: "POST", url: "../internal_request/ir_display_polls.php", data: { postId: postId }, success: function(result) { location.reload(); //$("#divSettings").html(this); } }); }

    Read the article

1