971 reputation
17
bio website valthor.net
location Reykjavik, Iceland
age 36
visits member for 1 year, 4 months
seen 7 hours ago

13 years of coding PL/SQL, T/SQL, and managing Oracle and MSSQL servers in enterprise environments. Mostly finance and telco


Jul
9
revised Null Or Multiple Parameters When Querying
added 208 characters in body
Jul
9
comment Null Or Multiple Parameters When Querying
Perhaps I misunderstood the requirements, I thought he was asking for a split function of some sort. But sure, my select statement didn't account for returning all rows for an empty string. I'll update that.
Jul
9
revised Null Or Multiple Parameters When Querying
deleted 32 characters in body
Jul
9
answered Null Or Multiple Parameters When Querying
Jun
17
comment How to reference a table from another schema inside a package?
It's little hard determining the problem based on this information. Perhaps you could post your code here ?
Jun
8
answered Shrink my database log file, make sense?
Jun
5
answered create a stored procedure if it doesnt exist using a ddl in db2
Jun
5
comment Slow delete caused by many foreign keys
There's really no catch-all answer for this, you have to tune your index needs based on the characteristics of your system. You might want to reference this answer here for details: dba.stackexchange.com/questions/5525/…
Jun
4
revised How do I differentiate between user-defined public synonyms and built-in public synonyms?
added 547 characters in body
Jun
3
answered Slow delete caused by many foreign keys
Jun
3
comment Mapping the oracle database directory object to a network path
As long as the path is accessible from your local server, it should work. "Oracle Database does not verify that the directory you specify actually exists. Therefore, take care that you specify a valid directory in your operating system. In addition, if your operating system uses case-sensitive path names, then be sure you specify the directory in the correct format. You need not include a trailing slash at the end of the path name."
Jun
3
answered How do I differentiate between user-defined public synonyms and built-in public synonyms?
Jun
3
answered Mapping the oracle database directory object to a network path
Jun
3
answered I can't connect to an instance of SSMS from other servers SSMS
Jun
2
comment Stored procedure performs worse than straight query
That is true, but you might want to be a little more careful with the RECOMPILE option, since constantly recompiling a procedure might give you a performance penalty when used with a large or a frequently used procedure.
Jun
2
answered Stored procedure performs worse than straight query
May
7
answered Export, based on query, into INSERT text file
May
6
comment Database design for handling 1 billion rows and counting
Is SQL server generating the GUIds for you, or is that generated in the .net code ?
Apr
9
answered How do I validate all my constraints in postgresql?
Apr
9
answered How to generate create table script without primary and foreign key in Oracle