Viewing 4 posts - 1 through 4 (of 4 total)
Found it..... So nevermind and thanks!
select s.name,l.loginname
from msdb..sysjobs s
left join master.sys.syslogins l on s.owner_sid = l.sid
January 7, 2015 at 12:28 pm
GilaMonster (10/1/2012)
You have some ability to influence the size.http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx
Excellent info, pretty straightforward management of it. Thanks!
October 1, 2012 at 10:00 am
GilaMonster (10/1/2012)Entire VLFs (virtual log files) only. If no log record in a VLF is needed for anything, that VLF can be marked inactive and hence reusable.
So the single log...
October 1, 2012 at 9:45 am
"in general, once a file is full, SQL can shift to a new file in the filegroup that has free space."
Thats what I was looking for. And thanks for...
September 19, 2012 at 10:56 am
Viewing 4 posts - 1 through 4 (of 4 total)