Hi All,

Thanks for all your reponses. I know for sure OLAP Cube is not the solution here because we are making changes on existing reports. My very concern now is...

I can confirm there is no parameter sniffings because I do not change paramters when calling the proc but I call proc with same parameters multiple times. Also, i can...

Does anyone know why SQL only generates parallel plan with Adhoc but NOT with stored procedure?

Hi Paul,

Don't worry about it and I got it working now.

Thanks again.

Attopeu

Hi Paul,

Thanks so much for answering my question. However, It works perfectly on SQL2008 but not sql2005. Is that possible for you to rewrite it to work for SQL2005?

Thanks again.

Attopeu

DistributedDate OrderNumber

---------------------------------

2011-05-16 23:50:14.0801.00

2011-05-16 23:50:32.4070.00

2011-05-16 23:54:10.8831.00

2011-05-17 00:14:12.3331.00

2011-05-17 00:47:27.4631.00

2011-05-17 00:50:32.7571.00

Here is my query:

select CONVERT(VARCHAR(20), DistributedDate, 112),SUM(OrderNumber) AS TotalOrders from FROM [Fact].[OrderDetails] S with(nolock)where...

I can only get to TransID,RadID and ProcID. I am struggling to get WU and GroupID correctly. Here is my query:

select

T.transID,

T.radid,

DENSE_RANK()OVER(ORDER BY T.procid)AS ProcID

from sarah_testTrans T

left join sarah_comboWU C

on...

Hi Lowell,

Actually I gave a bad sample data. I added a few more duplicate records but I really need to return ManagerID of 1430857. Also, I have more than a...

Hi,

This is not a row by row operation and I have to write query to join AddressInfo table to staging table. So, I don't think scope_identity will work here.

Thanks,

Attopeu

Hi Gail,

After recompiling the proc last night, the READs reduced from 18 millions to only 54 and I just can't beleive it.

However, I'm still confused why this could be a...

Hi Gail,

That's my next plan to analyze distribution statistics and I might have to update statistics with full scan per your suggestion.

Also, I cloned this production database to our Test...

Steve,

Does Santeri have his own blog?

Thanks,

Silaphet,

Steve,

I'm a big fan of Bob Dorr and I had one his showtime webcast. Do you know if he has his own blog?

Thanks,

Silaphet,

Fred,

We never ever touched server configurations. The server runs on thread mode not fiber mode. The NT Fiber option is unchecked. I don't think this is the case.

Any ideas?

Thanks,

Silaphet,

Eddie,

Of course, I've started the service with trace flag 1400. This is the first thing I did after installing sql 2005.

Thanks,

Silaphet,