Reputation
5,849
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 19 40
Newest
 t-sql
Impact
~194k people reached

Apr
28
reviewed Reviewed How to use a cross reference table for different features of a product in different versions?
Apr
28
reviewed Reviewed What to do when the active log directory is full?
Apr
28
reviewed No Action Needed Sql Server Management Studio slow opening new windows
Apr
28
reviewed Reviewed How would I script standing up a MySQL instance with certain specs?
Apr
28
revised How would I script standing up a MySQL instance with certain specs?
formatting
Apr
28
reviewed Reviewed MongoDB start ID and end ID
Apr
28
revised MongoDB start ID and end ID
formatting
Apr
28
comment Need help improving sql query performance
I'm not sure what you mean by your WHERE clause suggestion. ORDER BY A DESC LIMIT 1 would give you the last item (or at least one of the last items), whereas WHERE A <> MAX(A) basically means "all except the last item(s)". Perhaps it should be = instead of <> – still not an exact equivalent of the ORDER BY but certainly closer.
Apr
28
revised Need help with null field values
removing ambiguity
Apr
27
reviewed Reject Import a Oracle DMP file into a Fresh install of oracle
Apr
27
answered Need help with null field values
Apr
27
revised Need help with null field values
added details from comments
Apr
27
comment SQL Server: update trigger fires before insert trigger
@hot2use: The OP is aware that the order of execution can be set for triggers defined for the same statement type. That's not the issue here. The issue is that an update trigger seems to be firing before an insert trigger. There's no mechanism to specify the order in such cases. One would think, there needn't be, because an update cannot possibly precede an insert – and yet the implication here is that sometimes it can (or at least that the corresponding triggers may fire inconsistently with the order of operations).
Apr
27
reviewed Close What software or cloud service do you recommend PostgreSQL to get (more) interoperable with?
Apr
27
reviewed Close cannot call json_array_elements on a scalar
Apr
27
revised After update triggers that deal with multiple column updates
rephrased for clarity, added relevant tags
Apr
27
reviewed No Action Needed Versioning entities in db with draft option, select query
Apr
27
comment For about ~50,000 - 100,000 records, how much RAM is required for analysing?
Please note also that if your question is specifically about your Python project rather than about the database, then your question is just off-topic for this site. Database Administrators is for questions about databases and database administration. See help center for more information.
Apr
27
reviewed Close For about ~50,000 - 100,000 records, how much RAM is required for analysing?
Apr
27
reviewed Close Add new data center in EC2