Reputation
361
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 9
Newest
 Informed
Impact
~11k people reached

  • 0 posts edited
  • 1 helpful flag
  • 29 votes cast
Nov
27
comment How to recursively find gaps where 90 days passed, between rows
@GhislainLeveque yes. msdn.microsoft.com/library/ms189461.aspx
Feb
7
comment Why does mongodb virtual memory get so large
423784kB/1024/1024 = 0.40GB
Jan
13
awarded  Informed
Nov
5
answered Optimizing multiple MySQL sub-queries and joins for multiple runs
Sep
18
awarded  Citizen Patrol
Jun
14
answered How to group by when querying duplicate records?
May
31
comment Are there major drawbacks/risk of using oracle blob to store files
If there is no need for transactional support then let your filesystem do the job it was build for. Additionally you add a meta information file if you need to handle inconsistency later. The major drawback with blobs is a significant increase of your database backup/restore time.
May
30
comment What are reasonable options for an in-memory multi-core database?
Postgres in a ramdisk could even be slower. Your data is in the ramdisk (RAM) and when you query this data it is also in OS memory buffer (RAM). I don't think this would make things faster.
May
30
comment Run query faster, what index to use
Can you upgrade to postgres 9.2? This version can use index-only scans wiki.postgresql.org/wiki/Index-only_scans
May
30
comment Why Hypertable is not supporting joins and Transaction?
You can also read this. dba.stackexchange.com/questions/34892/…
May
29
comment Are there major drawbacks/risk of using oracle blob to store files
Do you need transactional support for this blobs?
May
29
comment Handle vast amount of data in DB
sql server...If you have to do some aggregation analyses over very large sequential datasets then you can store the results on a daily base to a other table. And this result can be aggregated again if need a result for the whole month etc.
May
29
answered Handle vast amount of data in DB
May
29
awarded  Commentator
May
29
comment Load Balancing in SQL
code.msdn.microsoft.com/Cloud-Fundamentals-in-1a3ab1bd
May
29
answered The UPDATE permission was denied on the object
May
29
awarded  Critic
May
21
awarded  Constituent
May
21
awarded  Caucus
Feb
22
comment Update to session table slow
cache will create contention issues I think this depends on your workload and is not generally true. My server runs with a query_cache_size=2048M and 6 cores a lot faster than without caching.