I would suggest you help us help you a bit:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Oh - if you did not know, always use "SQL Server Configuration Manager" to change service account information rather than directly in the services. The configuration manager does some...

Did you change anything with the service accounts after installing MSSQL and SSIS? I would recommend you go into the "SQL Server Configuration Manager" and change the service account...

SELECT * FROM ViewName

This is not bad if you really need all columns and all rows from the view. MSSQL will still use whatever execution plan it deems best...

Look for the services or open surface area configuration in the SQL 2005 start menu.

You could do that or possibly enable and use snapshot isolation - which would allow you to maintain a consistent version of the tables involved in your query without blocking...

It will not work. That is really a way of specifying an alias for the column name, it is not an assignment statement. You will need to call...

Rather than changing every field, you may want to figure out which fields actually need to be unicode and only change them. Depending on what applications connect and how...

I suppose so. Neither definition even specifies a computer be involved.

If you had a shelf with an abacus for each week displaying revenue, as long as you promose to...

First, you really should direct efforts to users never taking the results of reports and making modifications. I know this is sometimes difficult, but it is not only inefficient...

When you delete, it does nothing, or runs forever?

If you have foreign keys to this table (it being the PK table) every other table that may reference the record you...

Some system processes remain active from the starting of the MSSQL service to the stopping on the service.

If the processes in question are not system processes (coming from an application)...

Sorry, I did not test it.

Yes, I think it is the single quote issue.

Basically concatenate two zeros (as a string) to your number and then take the right 2 characters.

I don't think RAID 5 with 8 hard drives is 2x faster than RAID5 with 4 hard drives.

Regardless, RAID5 is slow and the first step to speeding things up would...

You can take multiple data flow streams and put them together using a UNION ALL component in your data flow. Then you will be able to direct them to...