Reputation
4,359
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
8 20
Impact
~355k people reached

Aug
27
answered selecting same column twice for different value
Aug
26
comment Artificially increasing query time
Can't you just write a query that takes longer time to execute ? cartesian join with the same table (especially multiple times) (e.g FROM CLAIM a, CLAIM b, CLAIM c ) will significantly increase time. You can also run other queries in parallel session that takes lot's of cpu time, so your query will get less. Also, you can modify the query and make it hierarchical which normally slows the query down.
Aug
26
comment Artificially increasing query time
dbms_lock.sleep ?
Aug
21
answered concurrent insertion in mutually exclusive tables in oracle
Aug
15
comment query optimization of a left join
It appears to me that this particular query is just an indication of performance bottleneck, not the problem itself. Note : rows_examined is less than 20k, such a query by itself can't take 10 seconds. The system seems to struggle for resources (I'd start checking all possible metrics), or there are some serious issues with hard drive.
Aug
13
comment Locking because of triggers mysql
Such a trigger kind of defeats the purpose of keeping table in memory - each update ends up persisting in innodb table which causes many locks. If you can't avoid storing data in persistent table, I'd suggest to replace UPDATE statement in the trigger with INSERT . I mean adding a new table, say pending_updates where you insert all the changes (by the trigger), and a stored procedure that runs periodically and reads data from pending_updates (potentially aggregates it) , and updates main table.
Aug
13
comment Locking because of triggers mysql
Can you post trigger[s] body ?
Aug
12
comment Performance problems with TOP and user defined functions in views
Check articles about plan guides, for instance msdn.microsoft.com/en-us/library/ms190417(v=sql.100).aspx . However, it appears to me that you're trying to solve ORM problems on SQLServer side. It's not gonna work in a long term even if you find a hack for this very specific issue.
Aug
11
comment Dropping Foreign Key In Production Environment
Just out of curiosity, what's the reason to disable unique check for the session? As far as I understand it's useful for imports, but nothing is imported within this session....
Aug
11
answered Dynamically changing an order number to end in _ERR
Aug
6
comment Oracle regexp_like square brackets inside character set
I don't think backslash is needed for escaping "]". select case when regexp_like('w[ord', '[]]+') then 'true' else 'false' end from dual; works just fine
Aug
6
awarded  Popular Question
Aug
5
comment Unique constraint error Oracle
It's hard to tell without any details about what the application is doing and queries, so I'm just guessing. I had such errors when data was synchronized, but sequences weren't (and sequences were used to generate values for primary keys)
Aug
4
comment Getting results without using IN
Check stackoverflow.com/questions/4722220/…, stackoverflow.com/questions/400255/…
Aug
1
comment Metrics for performance of Oracle
There are some other metrics that can be useful, such as wait event and time, parsing information, etc. But why not use Oracle tools designed for profiling . For instance tkprof, hierarchical profile, dbms_profiler ? They will give you all information about every single line of your code...
Jul
31
answered Is smallest to largest the rule of thumb in a multi-table JOIN?
Jul
30
comment MYSQL find if a default value has been set for a table (DateTime Specifically)
Check INFORMATION_SCHEMA.COLUMNS table, column COLUMN_DEFAULT . More info - dev.mysql.com/doc/refman/5.1/en/columns-table.html
Jul
29
comment Oracle migration to SQL Server
@jmonterohn : Then context_info won't work... As miracle173 said, temp table should do the job with some restrictions ( you will very likely end up with attribute-value table thus leaving type casting to the callee )
Jul
29
comment Oracle migration to SQL Server
@miracle173 : I agree with your argument that there is only one CONTEXT_INFO (however, I don't see anything in the question that implies presence of another package variable)... The trigger will be influenced in any case because it relies on an object that is supposedly created by some external piece of code...
Jul
29
comment Oracle migration to SQL Server
Package variables are not global, they persist for the duration of a session. In SQLServer you have similar behaviour (in your case) with ` CONTEXT_INFO ` - technet.microsoft.com/en-US/library/ms189252(v=SQL.105).aspx