For more info and a quick summary:

msdn bol

Local system is an account that only allows access to that machine in order to get off the machine when you are in a domain you should use a domain...

Click on 'SQL Server 2005 Service' and wait a few seconds all of the SQL services on that machine will appear. You do have to be local when you run...

Go to the SQL Server Configuration Manger look at the user that is listed next to SQL Server Agent in the "Logged In As" column. This need to be a...

When the package is run using SQL Server Agent it takes on the login of the Agent. Check the configuration manager for agent to see what is being used. This...

If you can assume that a null is zero!!

COALESCE ([field name], 0) + COALESCE ([field name 2], 0)

is clean with the large assumption above.

My normal flow is:

Backup

CheckDB

Rebuild/Reorg Indexes

Update Stats - I know this is somewhat redundant with auto stats on but I still do it

Clean Up backup history

The sizes you are listing...

I would definitely backup prior to any other operation.

Since you are running in simple mode the log file will not stay smaller than it is and will waste a...

MS provides a control flow object "Transfer SQL Server Objects Task" to accomplish exactly what you are trying to do I do recommend in general in these situations that you...

You're welcome it good to pass it on.

Alan

If depends on how you want to slice it. In you OLEDB data source you can specify a TSQL statement and if you can put that slice into TSQL this...

Great question! I have seen many co-workers create queries like this that work really well when all of the data can be copied onto memory on their test but when...

Is the name [Machine Name]/[Instance Name] ? If it is I don't believe it will respond and local.

This is why we recommend cold backups. We also recommend a scheduler to start/stop our default instance. But I suppose I can look into an OSQL (via an EXE since...

One issue I have run into is the restoration of the encryption key if it is lost from the server. If you have a copy of the master it is...