Reputation
5,839
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 19 39
Newest
 Reviewer
Impact
~193k people reached

1h
comment How to tune MySQL Data engine Innodb
I may be missing something here. How can the database size be 500 MB when according to your query the total data and index size is 91 GB?
7h
comment How can I partitioning oracle table when the table still working?
What if the table is referenced by other tables? Can all this be done without dropping or disabling the foreign keys?
2d
comment Getting error 1005(HY000) cant create table in MYsql
The cart table definition's got a typo in the referenced table name: instead of category it has catgory.
Apr
29
comment Adding templated Date-Time dimension to the cube
You can edit your question to remove obsolete information and add new details. Comments are primarily for clarification requests and may later be deleted.
Apr
29
comment PostgreSQL Index
In other words, an index is created on columns, not just on tables in general. Which columns should be indexed depends on which are queried often, as has already been mentioned.
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
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
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
26
comment variable declaration and alteration in a trigger
What database product (and which version) are you using?
Apr
26
comment normalize table data
What do you mean "it's rare"? There are indeed many questions of this kind here, as well as on Stack Overflow. Have you actually tried looking for existing solutions?
Apr
26
comment Trigger to calculate one column from other table
Do you really need a trigger? You could create a view calculating the employee counts for you each time you read from it. Anyway, what database product are you using?
Apr
26
comment Using a view to count specific values of a column
It's about aula count per monitor, not monitor count per aula. (And titulacao is a monitor column, too.)
Apr
26
comment Insert all dates from a month into a table
Do you want an insert trigger on period to insert rows into attendance?
Apr
25
comment Grouping operator in DBMS (γ) is duplicate-impervious. Why?
Is there perhaps a chapter in that book dedicated to explaining those operators in detail?
Apr
25
comment how to retrieve records in 3 tables
So you are trying to get all data from all three tables while matching related rows at the same time, correct?
Apr
22
comment Increasing the number of tempdb files question about initial size
If you are the OP, you can merge your two DBA.SE accounts by following instructions here. That will allow you to regain full control over the question. As a result, you will be able, among other things, to post comments on your question as well as on answers to your question.
Apr
22
comment Scripting SQL Server Replication
When you are suggesting your own material for reading, please disclose that it's yours.
Apr
21
comment mysqldbcompare SELECT command denied to user
@Oxid: It looks like you've accidentally created two accounts. You can merge them by following these instructions. Merging the accounts will let you regain full control of your question.
Apr
19
comment Rstudio (on Linux) Connectivity to SQL Server 2012
That looks like a development in your situation. You might want to update your question with that new info.
Apr
19
comment Rstudio (on Linux) Connectivity to SQL Server 2012
It says, One or more steps may have an *. See README for more information regarding these steps. Have you looked into README?