Once the cube is processed (assuming MOLAP storage) the data mart is not queries again until you process the cube the next time. So, you could have a horribly...

SELECT Col1, Col2, COUNT(*)

FROM X

GROUP BY Col1, Col2

A bookmark lookup means an index was used and once the value was found, the actual record needed to be "looked up" in either the clustered index or the heap...

First, your table names could be a bit more descriptive.

Try aliasing the table name in your sub-query. The optimizer may be getting confused by the D table being referred...

You have not specified the type of replication, but I will assume transactional replication by your description so far.

"Transactional" actually refers to the fact that the replication agent is actually...

You will save yourself a lot of headaches if you take another approach.

In the place in which you have the data flow task that is conditionally not run, set a...

Pre-execute is not just thinking about what it is going to do. It is actually running the stored procedure and filling the first buffer.

Pre-execute on some components in SSIS...

One partition per day? Having 700 partitions (one per day for two years) for any single table in your database is probably not really helping performance issues.

I tend to like the UPDATE rather than the DELETE / INSERT. It is not that it would be faster (it probably will not be) but it really represents...

You probably have created a cube with a bad join - making the result of every query no data. Recheck all of your dimension relationships.

First, make that a UNION ALL or you are forcing a DISTINCT.

I am not that keen on using these wrapper procedures around procedures or views, but it is a neat...

It seems a little odd that you would need the codes to be unique across several tables like this. I think you are trying to really support some sort...

FullText searching is a different type of querying. I would suggest you start by reading about it in Books Online and on the MS website and come back and...

Search google a bit.

Here is a place to start:

http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm

I have worked for a couple of mailing houses.

You would not believe how many people have names like that.