341 reputation
29
bio website
location Germany
age
visits member for 3 years, 6 months
seen 2 hours ago

2h
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
12
comment MySQL creates temporary tables on disk. How do I stop it?
It depends on your workload. From my experience it is most common that databases are memory and io bound and webserver are more cpu bound.
Nov
12
comment MySQL creates temporary tables on disk. How do I stop it?
Why is the database on a server with less RAM? You write yourself that your web server doesn't need much RAM ...
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