I like Jeff's solution as an example of how to do this in code.

We use a Fiscal Calendar table for a few of reasons.

It's easy to maintain, and it can...

Looks like he may have tested in Production :w00t:

That is a large font........

Greg E

Try looking over some of the documentation.

Here's a couple of links.

Hopefully this will help out. I imagine the

Greg E

http://msdn.microsoft.com/en-us/library/aa337557(SQL.90).aspx

and for RS

http://msdn.microsoft.com/en-us/library/ms157275(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms156010(SQL.90).aspx

I've got a problem that has me stumped. I downloaded an iso image with a long name to a usb key.

en_office_sharepoint_server_2007_standard_and_enterprise_edition_with_service_pack_1_x86_x64_dvd_x14-40187.iso

My x64 bit machine has no problem with this, But...

I would expect The Thread to come back for a visit and try for number 5000.

Greg E

I've been running W2003 R2 x64 bit on SP2 in both Dev and Production for awhile.

Apply it to your Dev environment and test it first.

I don't think anyone is going...

I use a similar strategy to move IIS log files to another drive.

This is VBA code in Excel example.

Note 1 difference - I order them and can choose how many...

Ill never forget Chevrolet took several...

If you are able to reboot the system and start out clean (which if this is production could be an issue), and then check the memory levels before any queries...

Are both SQL server and SSAS running on the same machine?

We run both on the same machine, but memory took awhile to balance out.

We had to set limits on both...

Understanding the current setup would be the first thing I'd look at. Look at the peak loads as well as normal average loads.

And if you are virtualizing, this is generally...

This sounds more like you'd want a KPI on a dashboard to point out those who haven't met some minmum requirement.

We let our rocks show as the water level gets...

Do the users need to delete records?

And if they are using access, do you know what ID is being used?

Could it be a data source setup as SA? That would...

We have 1 large cube with everything, and off of that we have perspectives. This sounds like what you are looking for.

http://msdn.microsoft.com/en-us/library/ms174803(SQL.90).aspx

Greg E

I see a Model of consistency - varchar(100).

Oh wait - now I can see why they did this.

It's flexible - you can put anything in a column.:hehe:

And I can see...