Reputation
15,617
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 54
Impact
~1.3m people reached

May
6
reviewed Close How to Store text of 15 to 20 KB file data in blob or as text?
May
5
comment unable to add index to column, duplicate entry
What is the definition of the index you are trying to add? Seems a bit odd that you'd have a timestamp as a PK.
May
5
reviewed Close Overwhelmed with Sensor Data - Excel to SQL fails
May
5
reviewed Close SQL server query is slow *without* including execution plan
May
5
reviewed No Action Needed Overwhelmed with Sensor Data - Excel to SQL fails
May
5
reviewed No Action Needed InnoDB Index Doesn't Fit in Memory
May
5
reviewed Leave Closed Who can explain mongodb with ssl?
May
4
awarded  Electorate
May
4
reviewed Close Cannot select features to install from SQL Server 2005 SP4 installation process
May
4
reviewed Approve transactional-replication tag wiki
May
4
reviewed Approve transactional-replication tag wiki excerpt
May
4
reviewed No Action Needed Postgres to Postgres foreign data wrapper, for tables based on queries
May
4
reviewed No Action Needed How to store user defined scoring formulas?
May
4
reviewed No Action Needed ERROR 1644 (HY000) at line 1852: Unexpected content found in the performance_schema database
May
4
comment Maxing out the shared pool's memory by executing many UPDATE statements (ORA-04031)
Are you using bind variables (prepared statements)? I'm guessing not, as that's more than likely the cause of the problem (many identical statements, apart from the liberals, filling up the shared pool).
May
4
awarded  Taxonomist
May
4
reviewed Close In MySQL why is the first batch executed through client-side prepared statement slower?
May
3
reviewed No Action Needed Handling of Topic Drill Downs in Databases
May
3
reviewed Approve pt-archiver and foreign keys?
May
1
reviewed No Action Needed sp_send_dbmail stored procedure send with attachment