RBAR from the client normally incurs the overhead of transferring large amounts of data over the network. Even so, the main issue of RBAR is with the high number...

I tend to always assume "it depends" when it comes to SQL Server. If it appears it does not, then I assume I'm missing something. We have existing...

I agree with TheSQLGuru. Even if the maintenance task has improved, it will be a long time before I trust them again. They were once a pain to...

I would still prefer the job being scheduled in the agent. This avoids putting all your eggs in one basket by counting on the one scheduler to be maintained...

It would be nice to be able to pass parameters between steps. I'm doing something similar. I would have liked to do the related T-SQL in a separate...

On one of our servers, we are having an issue reaching a DC during reboots. I notice that the agent can still start, however, none of the "next run"...

BTW, I am also trying to find best practices on the use of the service sid, group, or service account when assigning rights. So far, I think the SID...

Try using the local account "NT SERVICE\MSSQLSERVER". For named instances, "NT SERVICE\MSSQL$instancename". Type it in this in full. A check will verify and drop the NT SERVICE...

I think the ones with names like "#5B0AB761" are from table variables. If they hang around a long time, perhaps you should check for long running queries that would...

Perhaps http://technet.microsoft.com/library/Cc966545 or http://msdn.microsoft.com/en-us/library/ms176029(v=sql.105).aspx will help.

Maybe somethng in http://support.microsoft.com/kb/2015754 will help.

It is an old thread, but still a current issue. I have several jobs that log output to a file. I use the Job guid in the file...

Vince, SQLArg0 will have the first startup option, no matter which one it is. You need check each possible one until the desired startup option is found or the...

We also use a linked server and have seen the same errors in a trace log today. I was not looking for it, but we moved a database to...

Hi. Since you are using SQL Server 2005, you can use Notification Events and Service Broker. You don't have to do all the wiring yourself if you define...