It depends, if you install BIDSHelper you can just deploy any calculated measures that you've added without the hassel of having to got through a full deployment.

The other option is...

Actually the answer is Yes, the reporting service database doesnt need to be on the same server as the reporting services service.

we're actually talking about the base connection in connection manager, as far as im aware they dont use nvarchar(MAX), as a data type its likley to be DT_WSTR.

if you open...

No problem cory,

I'd recommend Dwains solution which uses the ROW_NUMBER() OVER

dwain.c (10/30/2012)

---

In the future, you should provide DDL and consumable sample data in the format I've included below.

-- DDL

DECLARE @T TABLE

(RecordID INT, ItemID INT, MaxOfCost MONEY)

--...

heres a quick and dirty way

CREATE Table #results

(

RecordId Int

,ItemId Int

,cost Decimal(38,2)

)

Insert into #results

values (43392, 3880 ,50.00)

,(39056, 3881, 93.75)

,(33941, 3881, 97.50)

,(33970, 3881, 97.50)

,(38950, 3881,...

Hi Cory,

DDL is Data Definition language, eg Table defs etc

DML is Data Manipulation language, eg the Select/Insert statements

I see you posted some sample data so I'll have a look...

Having come across this error a lot, its actually on the source connection, there must be data that is greater than the column length definition.

One way you can check this...

Can you supply the DDL and DML as well as sample data and expected results as this will help us understand the data and what results you want.

Is there a...

You didnt really need to restart the SQL Engine.

There are a few good resources abuiot, I have the MS press book :MS SQL Server Performance Tuning and optimisation, its a...

I'd not worry about using a CTE as in this case it really doesnt add anything to the query performance.

Thanks for the plan, Looking at the plan the index...

You can partition based on the Orderdate,

what you would do is Left Align the partition with the partition being set as 01-JAN-YYYY 00:00:00, this will then create stripes. ...

I suppose the first question is what state are the Indexes in, do you run regular Db maintentance jobs on the indexes?

If they are highly fragmented, then you could...

Actually your table design is not quite right.

I would set it up as

Create Table WorkPlace

(

WorkPlaceCode (PK)

,WRegn

,WorkplaceName

,NumberOfEmployees

,Address_Id

)

CREATE Table Employee

(

EmpNum (PK)

,EmpName

,WorkPlaceCode (FK)

)

CREATE Table Address

(

Address_Id (PK)

,Address1

,Address2

.....

)

This way you assign an...

Yes, all the permissions you need are on the MSDB database.

I think you need to assign them to the SQLAgentOperatorRole and db_ssisoperator role, but you will need to check if...