Posted by Eric Bartels

Today I was improving a printing-view of an application-page inside a project I’m working on. The “printing-mechanism” simply loads the page with a different symfony layout and includes custom css- and javascript-files which hide certain elements from the printing view. Unfortunately the page also contains textarea-elements which get scrollbars when the content is larger. This is [...]

Posted by clausbajor

In der Praxis trifft man von Zeit zu Zeit auf aufgeblaehte SQL-Queries, die ausserordentlich kostenintensiven und langwierigen Ausfuehrungsplaenen folgen. Zeigt eine weitergehende Analyse, dass die komplexe Abfrage eine oder mehrere Subqueries enthaelt, die mehrfach ausgefuehrt werden, dann besteht eine sehr gute Chance durch Verwendung der sogenannten WITH-Klausel, die Performance der Abfrageausfuehrung erheblich zu steigern. Im [...]

Posted by Sven Thämar

Folgendes SQL-Statement kann man verwenden wenn man prüfen möchte ob es blockierende Sitzungen gibt. SELECT , b.username blocking_username , b.osuser blocking_osuser , b.machine blocking_machine , b.program blocking_program , w.sid waiting_sid , w.username waiting_username , w.osuser waiting_osuser , w.machine waiting_machine , w.seconds_in_wait FROM v$SESSION w , v$SESSION b WHERE w.blocking_session is not NULL AND b.sid = [...]

Posted by Eric Bartels

One of my development systems is running on Debian Lenny (no this one does not host SharePoint). After update the system via apt-get update something went wrong and “core services” (samba, ssh) were out of order. It seems this is a bug in the packages provided by Debian. After struggling for a while a simple [...]

Posted by Eric Bartels

I use WinSCP for connections to remote linux-servers. WinSCP has a nice feature which allows the user to define custom commands. One pre-defined command is “File Compare”. It allows the comparision of local and remote files. The default-setting is not very comfortable. I simply added the following “code” as custom command. "C:\Program Files (x86)\WinMerge\WinMergeU.exe" /u [...]