-
View and kill processes in Linux and Solaris
On *nix system, the ps command is kind of like Windows task manager. It provides running processes information. Once you find the process ID, you can kill it using kill command. On Linux machines, you can type ps ux to list all your own running processes. The second column, PID, is Process Identifier. By looking…
-
Analyzing queries using DTA
I blogged about using Database Engine Tuning Advisor (DTA) to analyze your workload here. Like Indexing Tuning Wizard, you can also use DTA to analyze your queries. However, the way to invoke that is not obvious, because you cannot do it directly from within DTA. You need to have the query open in the Query…
-
Sending right string type from JDBC to Sql Server
In Java, the char data type is 16-bit, so it can handle Unicode characters. In a mixed environment where Windows and *nix (Unix, Linux, OpenBSD, Solaris, etc.) co-exist, when an app server needs to talk to Sql Server, it is pretty common that the app server is written in Java, and the connection is done…
-
Grant user permissions to create jobs in Sql Server 2005
Security model for Sql Server Agent 2005 has been revamped. DBAs will have better granular control over job creation, execution, and browsing. There are newly created roles in msdb for those purposes: SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole. For more information, go to this url in Book On Line: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm A lot of times, you may want…
-
Defining NO ACTION foreign key constraints in Oracle
In both Oracle and Sql Server, when creating a foreign key constraint on a child table, the default option is NO ACTION, meaning that this constraint will prevent the deletion or update of a parent key if there is a row in the child table that references the key. One popular option is CASCADE, meaning…