Reputation
8,164
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~376k people reached

Aug
29
comment How to dump PostgreSQL database whose owner has no password?
Yep. Once you got "FATAL: password authentication failed for user "santa"" and then "psql: FATAL: Peer authentication failed for user "santa"" - did you change something between the two?
Aug
29
comment User mapping problem during deployment
'I could not map it to any login' - why? Is there a login user missing or what?
Aug
29
comment Deciding the best way to partition (Postgresql)
A table definition and the typical queries could help a lot.
Aug
28
comment How to access a SQL Server database from other computer connected to the same workgroup?
Please don't add "thank you" as an answer. Once you have sufficient reputation, you will be able to vote up questions and answers that you found helpful.
Aug
27
comment Getting the employee history of Sales department from HR database in Oracle
Why do you use WHERE d.department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales') instead of a simple WHERE department_name = 'Sales'?
Aug
27
comment Junior DBA hopes for advice
While this is a valid question in real life (and I hope your boss appreciates your efforts), this site is not a good fit for it. Maybe you want to go to The Heap, the main chat channel of the DBA.SE site.
Aug
26
comment Is STRICT_TRANS_TABLES required for replication?
I would say that if the docs don't say it is needed for replication then it isn't needed. If you enable it does it make any harm (performance or other)?
Aug
25
comment Is STRICT_TRANS_TABLES required for replication?
What does the documentation say?
Aug
23
comment Optimize simple query using ORDER BY date and text
How is it that your query has no WHERE clause and there are still only about 70k rows instead of 1M?
Aug
23
comment Optimize simple query using ORDER BY date and text
Which PostgreSQL version do you use? Also, please edit the result of the EXPLAIN ANALYZE into your post.
Aug
23
comment Restrict access to rows by usename
Out of curiosity, what is the advantage of calling some tables _something? Unfortunately I don't know too much about MySQL stored procedures, but in PostgreSQL they could be the appropriate solution for you.
Aug
23
comment How to structure IF condition in MySQL trigger?
There is no OLD record when inserting something new. Have you tried NEW instead?
Aug
21
comment Difference between the given queries
Right. But my point is that doing more work isn't the real problem; it is doing it wrong. (In this case it makes no difference but there may be others when it would do.)
Aug
21
comment Difference between the given queries
Yes, this is what 'except the fact the second query seems to be doing extra and useless work of comparing two odetails' says to me.
Aug
21
comment Data in tables after DROP DATABASE and recreate
2008 and 2008R2 are different versions - which one do you use?
Aug
21
comment Using max for each sub group does not seem to work.
Could you be more specific? At least you should show how this relates to the question.
Aug
21
comment How to get table definition of a PostgreSQL table?
If you use psql, first issue the \set ECHO_HIDDEN on command then \d your_table_name - it will output the queries with which it collects the information it displays.
Aug
20
comment Query to list all tables in a schema
How does GO break? Sounds painful. Probably you should mention what errors do you get?
Aug
20
comment Schema Change/Update script for Database deploy
Although it is for PostgreSQL, you can collect some ideas from depesz's great article on the topic. We use it at my workplace extensively (and sucessfully).
Aug
16
comment Possible to have nested inserts in Postgres 8.4?
@John Well, I wonder what policy could dictate being stuck on an ageing system... 9.1 had some problems initially IIRC but it is rather stable these days.