Reputation
Next tag badge:
385/400 score
208/80 answers
Badges
12 88 203
Newest
 Revival
Impact
~7.8m people reached

Dec
28
comment Difference between Clustered Index and Unique Clustered Index?
possible duplicate of Is there any tangible difference between a unique clustered index and a clustered primary key?
Dec
28
reviewed Leave Closed What's the name for a script that can be executed any number of times with the same final result?
Dec
28
reviewed Leave Closed Store extra, optional information about any entity
Dec
27
reviewed No Action Needed Issues with Log Shipping
Dec
27
reviewed Close What's the name for a script that can be executed any number of times with the same final result?
Dec
27
reviewed No Action Needed Why doesn't row data show up in SQL Developer?
Dec
27
reviewed No Action Needed Should I add multiple secondary indexes to search
Dec
27
reviewed No Action Needed How can I set columns for an entire table in one UPDATE based on the SUM of a join table column?
Dec
27
comment MySQL cluster DataMemory and DiskPageBufferMemory parameters
If SQL nodes and Data nodes are separate, then there is no relation. I would still raise the amount of RAM and assign bigger buffers is you do not plan to store any data to disk on the Data nodes.
Dec
26
revised Commonly Used Acronyms by Database Administrators
added 79 characters in body
Dec
26
revised Commonly Used Acronyms by Database Administrators
added 189 characters in body
Dec
26
reviewed Close ~2 Billion row fact table in star schema on Oracle. Advisable?
Dec
26
revised MySQL cluster DataMemory and DiskPageBufferMemory parameters
edited tags
Dec
26
answered MySQL cluster DataMemory and DiskPageBufferMemory parameters
Dec
26
revised MySQL cluster DataMemory and DiskPageBufferMemory parameters
edited tags
Dec
26
comment Looking for an efficient way to clone tens of millions of database records
QUESTION: What version of MySQL are you running ??? (Please run SELECT VERSION();. QUESTION : What's the default storage engine ??? (Please run SHOW ENGINES;)
Dec
26
comment Looking for an efficient way to clone tens of millions of database records
QUESTION: Are all the PubChem data already stored inside a mysql database, or are you importing them into mysql for the first time ???
Dec
26
answered MYSQL - Unable to change 'old_passwords' variable
Dec
26
revised MySQL information_schema doesn't update
added 32 characters in body
Dec
26
reviewed No Action Needed “sqlplus as sysdba” startup error