Is it only slow when you have an SSIS project open, or is Visual Studio itself slow?

Visual Studio is a pretty bad memory hog, so making sure you have enough...

Why would you be deleting a database that a service needs without first turning off the service?

Then yes, since this trigger is SET-based and not using any sort of cursor, it is going to perform pretty well in a set-based update on the table. You...

Amost everything in MS SQL works better as a SET-based operation.

That being said, many triggers are poorly written and either cannot handle batch updates or simply serialize any operations anyway....

There is not a built-in option for this, but here is another thought - did you check the recycle bin on the larger server? Make sure it is enabled...

MS SQL uses a lot of information to determine what the best execution plan will be. The most common reason for choosing the wrong plan is bad information being...

The users own SCHEMAS. Either change the owners of the schema objects to dbo, or drop the schema's (if they have no objects in them).

SCHEMAS get created automatically in...

You can create the extra attribute hierarchies to support the "Day of Month" type of view you are talking about. I assume for your attribute hierarchy you used the...

If you only have tables, the conversion is pretty easy. Do just what you have said - create the schema and use an ETL tool to transfer the data....

These things always turn into a custom solution. You (hopefully) have foreign key relationships that you will need to make sure are still valid in the copy of the...

Where in the package is it actually becoming a date? Check the input and output collections for the source component.

If the actual value in the csv file is an...

The only things I can think of are using cross-database ownership chaining or defining a linked server (which can be back to the original server) and hard-coding another login into...

I would be very concerned about an ERP solution that crashes when it encounters a share lock on a table. I don't think I could program something to do...

You changed from 32 bit to 64 bit and changed from SQL 2005 to SQL 2008 at the same time. I also assume the hardware changed - is the...

No, it is not a bug.

If you have auto-generated dimensions, you do not get attribute relationships defined and you will probably find that if you expand the attribute relationships under...