Can it be related to the parameter  @TerritoryID parameter usage in the inequality clause? Because there is a huge gab between the estimated number of rows and an actual number...

• This reply was modified 3 years, 9 months ago by  ESAT ERKEC.

Erikur thanks for your interest about this issue.
You are exactly right because STR TO BIGINT CONVERSION   more expensive than other conversions.
If you allow me I want to use...

Thanks Eirikur;
I saw that thanks for your help.
In my thought  some  type of implicit conversions does not significantly affect  performance.
This insert statement is similar to this type.

 Thanks for your reply Eirikur  , Could you correct me if  am i wrong? In your test scrip , SQL Server  has some idea about the inserted values data type because it...

I made a test in SQLQueryStress at the same condition about two INSERT command and
there is a diffrence between CPU iteration avg cost so I insist on my claim...

No Thom they are seperated queries, I wrote that table creation script to show
table artitecture. In my thought implicit conversion cause this problem because it cosumes  some cpu

Thom I want to ask another think also in your approach the following statment does not cause to implict conversion because
the length of string values lenghts  are 50 but still...

Thom thanks for your answer but the test case is very simple  and what can cause to performance problem according to this
idea.  I am seeing Scalar Operator(CONVERT_IMPLICIT(varchar(50),[@2],0)) operation...

Hi Grant;
Could you share your bug report link?

Thanks

Hi Grant;
Thanks for your reply. 
Actually I thought that issue is  a bug but
SQL Azure default isolation level confused me. Therefor
I posted a question.

If you don t have mobile deploy I used it

smart app.

BEGIN TRY

EXEC sp_executesql @sql

END TRY

BEGIN CATCH

PRINT @sql -- I think you can see invalid statement....

END CATCH

Can you check Reporting Services Configuration Manager.

Database connection ,Service Account ,Web Service Url

May be you can find a Rest API for Cassandra to connect SSRS. According to my opinion It does not

diffrent then Couchbase

This are LOGO price and order tables 🙂

You can t return table in this function with parameter. You can insert a temptable with dynamic sql then you...