SQL Azure - query with row_number() executes slow if columns with nvarchar of big size are included (Network Steve Forum)

SQL Azure - query with row_number() executes slow if columns with nvarchar of big size are included

I am linking my question from Stack Overflow here. The link: http://stackoverflow.com/questions/27943913/sql-azure-query-with-row-number-executes-slow-if-columns-with-nvarchar-of-bi

Appreciate your help!

Gorgi

January 14th, 2015 5:52pm

Hi,

Thanks for posting here.

I suggest you to check this link and optimize your query on sql azure.

http://www.sqlusa.com/articles/query-optimization/

http://sqlblog.com/blogs/paul_white/archive/2011/02/23/Advanced-TSQL-Tuning-Why-Internals-Knowledge-Matters.aspx

Also check this blog which had similar issue.

https://social.msdn.microsoft.com/Forums/en-US/c1da08b4-265d-4ec8-a252-8d7090234e3e/simple-select-query-takes-long-time-to-execute-with-nvarchar-columns?forum=transactsql

Girish Prajwal

Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, January 15, 2015 7:01 AM
Proposed as answer by Guy Haycock [MSFT]Microsoft employee, Owner Wednesday, January 21, 2015 10:42 PM
Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Tuesday, January 27, 2015 9:48 AM

Free Windows Admin Tool Kit Click here and download it now

January 15th, 2015 10:00am

This topic is archived. No further replies will be accepted.