No.

To keep the log file size down, you either need to use simple recovery or do log backups. In your case, I don't think log backups will be a...

I would be VERY careful with any structural changes. Even adding an index could violate a licensing/maintenance agreement. It could also cause blocking or slow something else down.

Don't...

Too big leaves a lot of room for fragmentation on the disk. Try to size it reasonably. I usually take a guess for where to start based on...

Sorry, I was really unclear on the TempDB thing. Doing any splitting up of files onto the same physical disks is useless - and often detremental. The benefit...

If your reports use common connection files, switching from dev to prod is easy. In the project properties, there is an option to overwrite connections. Set the option...

I understand being stuck with a bad application, but since you are still implementing it, now is the time to try really, really hard to cut out the cancer before...

Were the cursors related to the locked records? That would be the first place to look. Is it an updatable cursor? If it is and does not...

Ok, that is a good check.

Did the spid have a cursor open?

Ok, if the two databases are really mirrored (correctly, that is) you should be able to specify both the primary server and the mirror using the SQL native client in...

You have to handle connection issues in the Control Flow - not the Data Flow. When a data flow component reaches it's pre-execute phase, the connections it uses are...

If you are having performance problems with this "new" application before implementation, now is the time to correct the issue and seek a new vendor for the software.

The problem will...

How did you determine there was no open transaction? You can be awaiting command with transactions open.

SSIS and SSAS are different products, their authentication does not have to work the same way.

However, although you can use lots of different authentications in SSIS to connect to different...

It seems a bit odd to assume your changes should be pushed out on a regular schedule. Are you always done with any changes every two weeks?

Skipping that, the...

Not really.

The only authentication Analysis Services supports is windows. You can give the "Everyone" group access to a cube and windows ignores the security. Or, you could create...