Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: 15 million rows and growing, so do the problem

    Well all your doubts are right

    I do am pushing 15 million rows in Table Variable as I do not have an identity column

    I am using the custom pagining and fetching relevant...


    Kindest Regards,

    Himalay

  • RE: 15 million rows and growing, so do the problem

    I used Indexes, Hints, Views, IndexedViews and god knows what not. The execution plan did not show use of these indexes. Obviously because I don't have any WHERE condition in my query 


    Kindest Regards,

    Himalay

Viewing 2 posts - 1 through 3 (of 3 total)