Reputation
6,266
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 21 34
Newest
 Nice Answer
Impact
~511k people reached

21h
revised Display both null and not null under same id but not both null or not null like XOR logic
added 9 characters in body; edited title
May
1
revised Cannot remove unused filegroups
added 16 characters in body
Apr
29
revised Does a single rollback affect all transactions?
deleted 2 characters in body; edited title
Apr
28
revised Oracle ROWID, can we assume it is sequential in a insert-only scenario?
Fix dead doc link
Apr
28
answered Oracle Exadata datafile distribution
Apr
26
reviewed Reject Why and how to index a MySQL database
Apr
24
revised MySQL Performance Tuning for MyISAM
deleted 159 characters in body
Apr
23
answered Redo/Noredo in Oracle
Apr
22
comment Why did a query change its execution plan and how to anticipate the change?
Check the last time statistics were updated for all involved tables & indexes (even if the indexes don't appear in the final plan)
Apr
21
comment Copying values from one table to another table which the column intended to be copied delared as default
Not sure I understand. Do you want the late_allowed column in attendance to have the default value for the rows you insert from the student table?
Apr
21
comment Incorrect database backup file size in SQL Server 2008 R2
What type of backups? What activity does the database have?
Apr
18
comment SAN Admin vs. DB Admin free allocated tempdb
Doing the cost (invest+maintenance) calculation of the 20% of purchased storage no-one can use can be enlightening for management. It's a good thing to have margins, and default monitoring policies, but blindly applying them everywhere is a waste of money.
Mar
8
comment Table redefinition ends with ORA-02448
Search for DBMS_REDEFINITION and ORA-02448
Mar
8
comment Table redefinition ends with ORA-02448
Did you search on support.oracle.com, there's a couple hits for problems like that.
Mar
7
comment PostgreSQL not using partial index when using boolean in WHERE clause
How could the db engine guess whether you're asking for the part of the data that is indexed or not? On top of that, you don't have a unique constraint on the name, so it has to search the whole table no matter what - looking for active ones via the index and inactive ones via a full search is a waste of time.
Mar
7
reviewed Approve How to fetch data that is not similar
Mar
6
revised Download SQL Server Developer Edition
deleted 8 characters in body
Mar
5
comment Huge database… queries too slow. How to improve performance?
Stop looking at those small details like vmstat or whatever. You need to rethink your design, then do some tuning. Your problem is those huge arrays stored as a single text column. Focus on that. Find another modeling.
Mar
5
comment Huge database… queries too slow. How to improve performance?
I'm not suggesting anything, you haven't described your problem in enough detail for that. Just that your current design and constraints just don't fit.
Mar
5
comment Huge database… queries too slow. How to improve performance?
Sounds like you need to completely rethink your design, possibly including the selection a relational database. (280G/30mil rows is not huge these days by any stretch. Large array of stuff in a column is a very big smell though.)