Viewing 15 posts - 76 through 90 (of 252 total)
When the trust for delegation is enabled, can I, as a sysadmin, use SQL Server to impersonate the domain admin account?
We have a vendor that claimed they don't...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
December 17, 2013 at 10:49 am
Another issue I've seen is RBR -> RBAR. If something somplace requires processing a row at a time, then that's the way it's all done. For example, sending...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
December 11, 2013 at 2:21 pm
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
December 11, 2013 at 1:35 pm
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
December 9, 2013 at 11:02 am
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
May 20, 2013 at 10:06 am
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
May 17, 2013 at 10:15 am
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 2, 2013 at 5:55 pm
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"...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
February 4, 2013 at 1:34 pm
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
October 29, 2012 at 4:27 pm
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
October 29, 2012 at 3:44 pm
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 9, 2012 at 10:13 am
Perhaps http://technet.microsoft.com/library/Cc966545 or http://msdn.microsoft.com/en-us/library/ms176029(v=sql.105).aspx will help.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 9, 2012 at 10:07 am
Maybe somethng in http://support.microsoft.com/kb/2015754 will help.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 12, 2010 at 11:43 am
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
April 12, 2010 at 11:28 am
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...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 3, 2008 at 7:06 pm
Viewing 15 posts - 76 through 90 (of 252 total)