You do take a performance hit. Every transaction needs to maintain the previous version of records impacted while the transaction is running. The impact (in my experience using...

If it has been migrated, it is now an SSIS Package.

Add a job step and select the Integration Services Package step type. You should then be able to select...

You have to do this from separate connections.

Do you have an application that will allow you to look at the contents of your log file? If you do, look at what is logged. You will...

You have a table that has a single integer field and it is a heap.

Every time a transaction is logged against this table, it has to include both the piece...

Detach / Attach will be faster because it does not have to do the restore part, but other than that the result will be exactly the same.

Make sure you update...

There is a path in that file - make sure you did not mess it up.

Between the ServerName tags replace the period (.) with ServerName\InstanceName

If I remember correctly, the SQLBrowser service has to be running for resolution.

Um...nope.

You may or may not have noticed that when you modify a table from Management Studio (or EM for that matter), it often creates a new table and copies over...

Look at CAST OR CONVERT

CONVERT(DATETIME,'1/1/2000')

If I am reading this correctly, you have 3 instances on the same physical server - so you do not want to reboot, you want to stop and start the...

You have pluralized "clustered index" but you can only have one per table, so I am not sure if you have you indexing correct, but I will assume it is...

In the "email addresses" tab for the information in your GAL you should find the email address for the distribution list without spaces. It could be anything. You...

I hate the hint you are referring to.

It shall remain un-named for a bit longer.

Don't truncate the log file unless you really have to. A transaction log backup clears the log file but leaves it allocated on disk. Every time you do...