Estimated Execution Plan is in below attachments

Yes, the execution plan is for FORCEPLAN ON. I can not take execution plan for FORCEPLAN OFF.

Now, i am preparing table and index scripts.

Query:

SELECT

SAP_DB.URP.MAKT.MATNR,

SAP_DB.URP.MAKT.MAKTX,

PLY_V.dbo.DIM_PRODUCTMAINCATEG.dim_productmaincategdesc,

PLY_V.dbo.DIM_PRODUCTCATEG.dim_productcategdesc,

PLY_V.dbo.DIM_PRODUCTBRAND.dim_productbranddesc,

SAP_DB.dbo.BUTCE.YIL,

SAP_DB.dbo.BUTCE.AY,

Sum(SAP_DB.dbo.BUTCE.TUTAR),

Sum(SAP_DB.dbo.BUTCE."MIKTAR(KG)"),

SAP_DB.dbo.BUTCE.SIRKET,

SAP_DB.URP.T880.NAME1

FROM

SAP_DB.URP.MAKT RIGHT OUTER JOIN SAP_DB.dbo.BUTCE ON...

Every Night, statistics are updated and indexes are rebuilt. All queries take for long durations. It is not specific to one query.

It is impossible.

Mirroring requires FULL Recovery Model

Now, I opened a case to microsoft.

This is a DWH system. There are only clustered indexes.

Slower queries' server has the newest SQL Server version number. And all other factors are the same.

http://www.microsoft.com/downloads/details.ASPx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en

Let's try to check above link and download that driver, it might need restart.

Which provider do you want to add? Because some other DB providers need to install their client utility. And i think, those values are read from registry. And you might...

You can open a DAC connection, if the problem is caused of sql server. And try to search the reason of problem via DAC Session.

Let's try it with CREATE TABLE and INSERT Statement. I only wanted to show as sample like that.

declare @Table table (name varchar(15),cnt int,value int,xString varchar(16))

insert into @Table values ('00025#',4,250,'Pedro'),

('00027#',10,40,'Marco')

SELECT

n.RowNum,

Image.name

into Test2 --initial insert

FROM (

SELECT name,cnt

FROM @Table

) Image

CROSS APPLY (

SELECT TOP (cnt) RowNum = ROW_NUMBER() OVER(ORDER BY a.[Name])

FROM...

Also You can use this recursion instead of spt_values:

declare @Table table (Doc_Nbr int,Ticket_Nbr int)

insert into @Table values

(12,907),

(12,908),

(12,909),

(12,913),

(12,915),

(14,1481),

(14,1484),

(14,1485),

(14,1486),

(14,1487),

(14,1489),

(14,1490);

WITH cteSequence ( number) as

(

SELECT 800

...

Here is the final solution:

declare @Table table (Doc_Nbr int,Ticket_Nbr int)

insert into @Table values

(12,907),

(12,908),

(12,909),

(12,913),

(12,915),

(12,919),

(14,1481),

(14,1484),

(14,1485),

(14,1486),

(14,1487),

(14,1489),

(14,1490);

WITH C AS(

select Doc_Nbr,Ticket_Nbr,DENSE_RANK() OVER (PARTITION By Doc_Nbr ORDER BY Ticket_Nbr) as rownum

from @Table

)

select b.Doc_Nbr,a.number

from MASTER.dbo.SPT_VALUES a...