Reminder: many (all ) of the Microsoft visual tools are still 32 bit. So on a 64 bit platform, I'd recommend installing boith 32 and 64.

Actually, to be clear, you have to turn on logging. (It's off by default.)

Initially, I would suggest you log every query, then back it off once you've got a good...

Since your query takes about 20 seconds, how long does your RS report take? What response time are you expecting? A million rows should be no big deal (and faster...

No problem. We all have those days.

Reminder: Really recommend you include the image as part of your Report Server implementation, unless it makes perfect sense to have it hosted externally...

If I can add a few clarifications:

Most likely, you'll want to run 32 bit Report Services, even on x64 hardware. The reason is, that Report Services runs in IIS and...

Try using an "external" image source.

I suspect the embedded source won't work, because it may not be properly parsing the expression code.

=Iif (Value = 1, "Http://..../Image1", "Http://....//Image2")

This works for...

Try using the slowly changing dimension method in SSIS. Sounds like this does exactly what you need.

P.S. You can also use this to get a record of how many updates...

Got it (I think):

I recommend you use SQL Server 2005, Enterprise. You'll be able to define partitions and maitenance will be a snap:

To extend a new period:

alter partition...

It's not clear from your note, but I'd stronmgly recommend youy use the partitioning feature in SQL Server 2005. This'll allow you to segment the data easily on an available...

Sounds like you're getting yourself into quite a box. It's difficult to offer precise suggestions, since you haven't listed much about the application you're attempting to do. However, a couple...

All great points and feedback. If I could add one more wrinkle:

Since you posted this into the BI forum and since we're talking about data warehousing, you really should consider...

Basically, there's a couple of things you should do:

- ensure that only dimension records with valid data is flowing into your cube. Some people mistakenly load all (future) periods, which...

Choice of tool depends highly on the specifics of your environment. I've used both ERwin (from CA) and ERStudio (from Embarcadero) to great success. However, for light usage, the tools...

Try restoring it to another machine, just in case there's an issue on that server. Then, if successful, make sure you dump the definitions and do a clean build.

NB. Recommend...

Can you be a little more clear on the steps you're trying to implement and/or the requirement. I've never had to  make the adjustments you're referencing, and I use VARCHAR all...