Reputation
2,172
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
6 19
Newest
 Constituent
Impact
~115k people reached

Aug
20
comment Is it poor practice to aggregate data from different tables into one?
Like you say, it is theoretically possible to make triggers work. It's just that in practice they never do.
Aug
14
revised Is it poor practice to aggregate data from different tables into one?
added 170 characters in body
Aug
14
answered Is it poor practice to aggregate data from different tables into one?
Aug
12
comment Can PostgreSQL use nulls in its indexes?
@FuriousFolder: You are describing an index-only scan. But the OP says that his indexes are not being used, which wouldn't happen if an index-only scan would satisfy the query.
Aug
11
answered Can PostgreSQL use nulls in its indexes?
Aug
4
awarded  Constituent
Jul
31
comment Stored procedure with recompile
Not sure what's wrong with with recompile. MSDN refers to it in the context of parameter sniffing: msdn.microsoft.com/en-us/library/ms190439.aspx It's not fine-grained or elegant but it gets the job done.
Jul
28
awarded  Caucus
Jul
18
comment How to validate column while creating Table?
Security is not the right way to defend yourself against developers. Write a script that periodically checks for non-conforming tables and emails the DBA's,
Jul
18
comment Restore a large number of transaction logs
+1 I can see why the use xp_cmdshell might lead to downvotes, but this sounds like exactly the time and place for quick & dirty :)
Jul
17
comment Finding optimal indices, different query competing indices
@mark: A temporary table lives just as long as the transaction. Postgres creates temporary tables under the hood to store the results of joins, hashes, subqueries and so on. We have queries with temporary tables that run 50 times a second.
Jul
16
comment PostgreSQL, merge join results
What output would you expect for a user who has a matching row in both the study and the job table?
Jul
16
revised PostgreSQL, merge join results
added 22 characters in body
Jul
16
comment Filter and append data to row
@ErwinBrandstetter: Looks like json_agg supports an order by clause, like json_agg(row order by row.col1)! That avoids the "will usually work" part.
Jul
16
revised Filter and append data to row
added 408 characters in body
Jul
16
revised Filter and append data to row
added 3 characters in body
Jul
16
comment Filter and append data to row
Wouldn't the query optimizer be free to drop the order by in the subquery?
Jul
16
revised Filter and append data to row
added 114 characters in body
Jul
16
revised Filter and append data to row
added 639 characters in body
Jul
16
answered Filter and append data to row