Thank you very much for your time.

We have taken performance reading of both SQL version and identified whenever we used ROW_NUMBER,Rank() functions;SQL Server 2017 express edition generated different plan and...

• This reply was modified 4 years, 8 months ago by  nirav.gandhi7.

Hello All,

I have added a dummy query. I can't give actual table details. but the error was having on Table variable but not in # table.

Above code is just an...

Thanks. but right now we are not going to change any objects on current database.we have very stable product so we will consider your point in future.

Thanks for...