In some respects, you can. If you right-click on an OLEDB source and open the advanced editor the field definitions can be configured. You could even spend the...

Partitioning and configuring File Groups are very different. If you have a very large data database environment, you are likely to want to configure both. I would recommend...

I have had this issue as well. I'm blaming it on the oracle client not working correctly. I think it is reporting information incorrectly to the OLEDB driver....

Run VS2005 and 2008 side-by-side - they do not interfere with each other. Use VS2005 for BI development (SSIS, SSAS, and SSRS) and use VS2008 for application development.

Calculated measures work fine, but they are calculated so depending on the MDX you create, they can become a performance issue. The best way to determine if they are...

I'm not sure what the developer you spoke to said, but whether or not ADO can create a recordset has nothing to do with the underlying query being based on...

Is your SQL Server running on VMWare?

So you are really trying to keep your test environment updated.

You have some options. If the application does not update the database in the test environment in any way,...

That is a pretty vague question. There are several types of replication (Transactional, Merge, etc.). You need to first determine what type of replication suits your needs. ...

I have used XSQLCompare, Red-Gate, and Quest SQL Compare over the years and they all work ok. I do like the Red-Gate package UI better than the others, but...

Funny - I made the post you are referring to.

I was mostly making the comment in reference to Excel. Before Excel 2007, there was a limit of 65000 rows...

SQL does know what indexes to update and what ones not to, but your clustered index has the data pages, so it will always be updated.

My guess is that you...

With a constraint, you can possibly bulk insert with constraints off or you can simply disable a constraint.

I don't think it is much risk, but I suppose it is possible.

I...

I just read a really good article that explained all of this, but I cannot find it.

I think it was on this site too...

Regardless, I agree with approach 3. ...

If you are using the schemas for the purpose of securing the data in one table vs. the other and only giving users access to one of them, using the...