Here is the configuration of our Production server:

Windows server 2008 R2 Enterprise

4 processors

Installed memory(RAM): 128GB

64 bit OS

Below is the info on the Memory which I got from the sql server...

The application we have is MS Dynamics Navision ERP, the application data seeks are slow in production. Like I said it's fast in Test environment. We ran the trace for...

Thanks for your quick responses.

No, I am not ignoring what you are saying, since I am testing in development so I wanted to try the last option of repair_data_loss.

This is...

I ran DBCC CHECKDB (Database,REPAIR_ALLOW_DATA_LOSS) and I got the below error:

DBCC results for 'Database'.

Msg 8979, Level 16, State 1, Line 1

Table error: Object ID 7, index ID 1, partition ID...

Thanks for the reply, it's sql server 2005 version. Actually I have this issue in the actual production environment. So to fix this issue, I took the backup of that...

Here is the attachment that will be the output upon browsing the cube. Thanks.

Bob Hovious 24601 (10/14/2009)

---

Couple of observations:

1. You don't have daily data, yet you say you want to calculate MTD (month-to-date). Did you mean to say YTD...

For...

Actually this code is for the source:

(

SELECT ordername, ordertype, ordernumber

FROM TABLEA a

INNER JOIN TABLEb b ON a.ID = b.ID

)

Per your example I shall insert this code's data into a @source...

right click on the table, select properties, then change the dataset name to the desired dataset.

Since dept_ID of Employees table is a foreign key to the Departments table, what values do we insert into Employees.dept_ID field?? Thanks.

Please let me know. Thanks!!

Thanks for the reply, actually instead of passing in the orderdate parameter, the users want to pass in the order month and year as parameter.

When the month and year...

Thanks for the replies, that was helpful. I cleared up some space on that mdf file drive. As far as I understand there's not much we can do other than...

Sorry my bad, I know why I was getting the error:

multi-part identifier could not be bound.

Thanks!