What RAID type are you using? Maybe a hardware based 0+1 is needed. This is recommended for mission critical 24/7 systems.

Rather than maintain two copies of the same file, Import then move the file all in one loop.

I think SSAS does the proper thing by wanting to have all fields defined. In your dimensional database, It is common to put a -1 key to represent a null...

Snapshot replication is usually a good option if you generally have lots of activity happening on a large database. I would not recommend snapshot replication since this would replace the...

One issue with stored procedures in reporting services is that if the stored procedure is quite complex, e.g. has multiple select statements, that SSRS has trouble parsing them correctly to...

Try this also...

With Member [Measures].[Thing Count YTD] As

AGGREGATE(YTD([Effective Date].[Year-Week].CurrentMember)

, [Measures].[Thing Count] )

SELECT

[Measures].[Thing Count YTD] ON 0,

[Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1

FROM

[Cube]

This keeps whatever it is you are...

It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.

🙂

Sorry to hear this. I won't ask for details.

Cheers

INFORMATION_SCHEMA columns do not have exactly the same information as sys.columns, but it may work depending on the need. Overall, sql server 2000 just does not have all of the...

Maybe the clustered index that re-arranged the pages created disk fragmentation?

Also be sure your column emp_status does not contain nulls or else a

emp_status !='01'

will not return the nulled columns. I don't know if this is the intended behavior.

So you deleted a local user account? Be careful this does not cause issues in other areas.

Hi,

Look into the function "ParallelPeriod" in...

The US post office has a NCOA (national change of address) service. They in the process maintain a standardized version of US addresses. There are companies that buy/rent this data...

Model your business processes, that will light what are your facts and subsequently your dimensions. If you are familiar with your business this shouldn't trouble you too much.