I usually include an identity column on my fact tables and make that and some kind of additional field as the PK for the table. The only reason for...

When database mail sends an email with an attachment, it finds the attachment in the absolute path specified. This path is relative to the SQL Server, not to the...

The OLEDB Command is what you would want to use in SSIS.

Yes, it will insert or update one row at a time. That is what SSIS does and it...

Are you pulling data from the two data sets in the same data flow?

If you are, there would be very little "extra" overhead in sorting your data sets and using...

It's going to depend on the amount of data you are importing, the amount of data in the lookup tables, and number of lookups, server configuration, and a host of...

Sounds like a complicated way to avoid using an identity column. Why aren't you using an identity column?

Nope.

Well...it depends on what you are doing.

A SQL Command can use a file as a source for it's command and the file can be larger than 4000 characters.

If you are...

Use the Reporting Services Configuration utility.

It will be in the start menu group for the SQL 2005 configuration tools. The tool should walk you through configuring the reporting service...

11M is a bit much for a lookup.

You could use a second data source and a merge join, but you will probably get the best performance out of staging the...

The standard is to use surrogate keys on every dimension table regardless of needing to or not. I would recommend doing this in nearly every situation.

It does mean that...

The error variables are scoped to the error handler.

Click the "Event Handlers" tab, create an error handler, then look at the system variables in the variables window.

You can also enable...

By default, transactional replication creates a bunch of stored procedures on the subscriber that handle your inserts, updates, and deletes. Feel free to go look at them.

The default behavior...

You can configure memory to be dynamic or static. If you use dynamic memory allocation, you can specify a min and max. You can configure the amount of...

The DBCC command to "PIN" a table in memory was dropped with SQL 2005. It is my understanding that there is no replacement.

SQL 2005 will retain your table in...

That's the approach I would take as well (except I would use upper-case for some reason).

As an alternative, you could go to the advanced tab of the lookup control, turn...