Sounds like parttioning and incremental updates are something to look at.

http://msdn.microsoft.com/en-us/library/ms133905.aspx

You also might want to look at slowly changing dimensions too. How you handle these would also have some impact.

Greg...

In the Help file, the feature matrix lists x64 support for Standard and Professional editions, but not Developer edition. Std and Pro both also have Enterprise console, so installs from...

SQL 2005 seems much more granular in security, and the default in many cases in more restrictive.

If you can test Basic Authentication on a web site, you can see if...

What context is the Application Pool running under?

Sounds like Network Service.

If NTLM fails, this is the account that likely will be tried.

Greg E

Robb -

These links should help you out. You could also use Basic Authentication, although I'd recommend an SSL certificate.

If you're happy having generic access under the Network Service ID, leave...

rhagan (7/2/2008)

---

Greg-

Thanks for the response.

We have a fairly straight forward setup for our Intranet - one server for web and database; user logins via Windows authentication; running IIS 6, classis...

The ASP.Net pages - the context being used is not always what you expect. Especially when making a hop between servers. If you're using NTLM on the site, switch to...

I'd like to see how you get support if you have issues running RC 0. 😀

Greg E

You might want to start with quest. I seem to recall this when we changed out servers and went to a quad core on x64 bit. The licensing was different.

Greg...

One query to get subscriber info from SQL table using SQL source.

Query for the report will use SSAS data source instead.

So you need 2 different data sources.

Greg E

You may want to look at SP2 at a cumulative release level 3 or above.

SP2 broke our partitioned cubes.

We're on x64 bit and had experienced the occasional 'hang'. Mostly on...

We use triggers to capture the keys on new / changed / deleted records on the AS400 side.

This minimizes the amount of data we need to pull over to sql...

We transfer data nightly just as you want to do.

We have a process that runs on the AS400, and when it is complete, we issue a remote command to SQL...

The screen indicates the setting is in MB. So 2048 would be the number after you've got 4GB installed.

If you want to go nutz, run SSAS on the same box....

2048MB is just over 2GB

SQL Server likes memory. And if a database is worth anything, it will grow.

Just make sure you leave the OS enough free memory. If you have...