Reputation
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 13 24
Newest
 sql
Impact
~201k people reached

46m
comment Passing filter params to a sub query
That syntax doesn't work on Oracle, so it's not useful.
50m
comment How often will a FOR EACH STATEMENT trigger execute if the operation is caused by an FK constraint with UPDATE CASCADE?
You could create a test case! Insert into another table in the body of the trigger and see how many rows you get. Then write it up in your own answer to this question (that's allowed, encouraged even)!
52m
reviewed Reviewed Spatialite: use of virtual spatial index for distances
1h
revised pgAgent Job's “last result” is continuously “running”
deleted 21 characters in body; edited tags
1h
reviewed Reviewed SQL server 2008
1h
revised SQL server 2008
deleted 12 characters in body; edited tags
1h
reviewed No Action Needed pgAgent Job's “last result” is continuously “running”
1h
reviewed Close Do I need a database license for my application?
1h
comment Periodically update a table with new records from another server
Be very careful with your logic to determine new or updated rows. "last updated timestamps" are dangerous to use as they are set when the record is inserted or updated, not when the transaction is committed. If there are long running transactions you could easily miss new or updated rows. The process becomes much easier of course if there are only new records, but you still have to be wary of missing data. Change Data Capture gets around all of these issues by offering trigger-like semantics by maintaining a log of changes for you.
1h
comment Periodically update a table with new records from another server
Maybe SQL Server Change Data Capture will be useful for you? msdn.microsoft.com/en-us/cc645937.aspx
14h
comment Connect to Oracle using SQLDeveloper using OS Authentication on a remote machine
Setting remote_os_authent to TRUE is a very bad idea and your sentences on this should be bold and in red :-) And the parameter is deprecated in 11g and higher.
14h
reviewed Leave Open sys.sp_reset_connection. Why theres a lot of them ?
14h
reviewed Leave Open Sudden poor SELECT performance on a large table with existing indexes
14h
reviewed Close Excel connecting to SQL Server Database and editing tables
14h
reviewed Edit SQL Server connection failed for domain user from Mac OS machine
14h
revised SQL Server connection failed for domain user from Mac OS machine
Removed chattiness.
15h
reviewed Close How to order by alphanumeric codes in SQL Server
18h
reviewed Close Recover master database
18h
reviewed Close SQL Server Disk IO Performace appears different between otherwise identical servers
18h
reviewed Close DBA vs DB Engineer vs DB Programmer