When you are selecting your articles, you can right-click on each article and set some properties of the destination article. Included in this is the schema - it does...

I think you will end up with a correlated sub-query any way you handle this. Here are a couple of options:

[font="Courier New"]SELECT * FROM IssuesTable I

WHERE I.CreatedDate <= '2008/07/02'

AND...

If you are using the Enterprise Edition of SQL Server Reporting Services, what you are describing is a data-driven subscription and you don't need SSIS at all. A data-driven...

Regional settings are part of the user profile. Did you log in as the SQL Agent service account when you checked the server?

You have to be more specific. White space is a generic term that includes spaces, carriage returns, line feeds, NULL, etc. In many cases, you need to retain...

It's a 64 bit world now. Embrace it.

I would not go with Itanium in most cases (you would know if you actually had a need for it), but it's...

Right, so your price column is your additional grandularity. Normalize your data - don't repeat columns that will always be the same.

I don't have the details, but if you...

I typically like to create template files for exports to Excel.

In the case you are describing, I would create a workbook with 5 sheets in it. Four of the...

Report Manager security is just that - security for Report Manager. The Report Server web service does not take that security into account.

You "should" handle security in two layers....

The Slowly Changing Dimension transormation does not update data that has not changed. I have found it to be very effective on tables with less than 1000 records. ...

By the way the ftp protocol works, even if you had a tool that copied from one FTP folder to another, it would have to transfer each byte locally and...

Measures have a format property that you can set to use a period rather than a comma for numbers.

As far as the NULL question, it depends on what you are...

The number of CPU's and the amount of memory are two different resources determined by different factors. They often have little correlation to each other.

Without some background of what you are actually storing and how the grandularity has changed, it will be difficult to help.

Usually, it is not really that the entity you have...

My post dropped out and I just noticed.

You do have a great deal of control over transactional replication. By default, it creates stored procedures for it's inserts, updates, and...