![]() SELECT the ‘15000’ (milliseconds) timeout to a reasonable time for your application.Ĭategories: Reference, Solved Problems, Windows | Comments SPF exists for a reason, and postfix makes it ridiculously easy Unknown bolt | SELECT = + 'kill ' + CONVERT(varchar(5), req.session_id) + ' 'ĬROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext where req.total_elapsed_time > 15000 If you want to kill all long running queries in a single go, try something like this: DECLARE varchar(8000) = '' without the brackets, where session_id is the corresponding column output from the query above I have to admit this is cargo cult SQL to me, but here’s how to find running queries, sorted by their total elapsed time: SELECT. I archived a copy here.Ĭategories: Reference, Solved Problems, Windows | Comments Find and kill long running MS SQL Server queries Unknown bolt | ![]() Drag the quick launch to where you want itĪ more detailed description can be found here.Right click the toolbar header at the left side of the quick launch.Right click the taskbar again and unlock it (click “Lock the taskbar”).Notice the “Quick Launch” appearing next to the systray.Enter “shell:Quick Lauch” into the “Folder” field and press enter (note the lack of a space between : and Q).Well, Windows 10 can do this too, though it is slightly harder to enable than on previous editions of the operating system. Thus they all stay neatly in place next to the start button. The classic “Quick Launch” solved this by only displaying a launch shortcut, and never turning into the actual taskbar entry for the program it launched. In turn, this means that my pinned programs are almost never where I expect to find them, and I have to look around. This means that when I pin programs to the taskbar, opening one of them, suddenly making it display a title for one or more windows, will push any pinned programs to its right further towards the right edge of the screen. I have my taskbar set to “Use small taskbar buttons” and “Never combine”, probably as much out of habit as anything else. Update-alternatives -config x-session-managerĬategories: Linux, Reference | Comments Enabling Quick Launch in Windows 10 Unknown bolt | Update-alternatives -config x-window-manager I now use the default environment, but it’s here in case anyone finds it interesting anyway apt-cache search kali-desktop Systemctl enable rvice Set a custom default window manager (like xfce) Gsettings set .power power-button-action 'shutdown' Encrypted swapįor separate partitions, use the existing guide for Debian.įor swap files in encrypted filesystems, do this: dd if=/dev/zero of=/.swap bs=1G count=16Įcho "/.swap none swap sw 0 0" >/etc/fstab Disable auto-locking and that stupid slide screen gsettings set idle-delay 0 Install qemu and virt-manager apt-get -y install qemu-kvm virt-manager Note: shutdown option missing as of gsettings range .power power-button-action Settings => Keyboard => Input Sources => Remove superfluous keyboard layoutsĮdit /etc/gdm3/nf AutomaticLoginEnable = trueĪutomaticLogin = root Enable smartmontoolsĮdit /etc/default/smartmontools start_smartd=yes Shut down with power button. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |