Reputation
4,336
Next tag badge:
120/100 score
16/20 answers
Badges
4 24 58
Impact
~518k people reached

Mar
20
comment how to check and list all the files related to mongodb in ubuntu? I am looking for config files, password informations for mongodb
There is no need to delete the question. Welcome to dba.se!
Mar
20
comment how to check and list all the files related to mongodb in ubuntu? I am looking for config files, password informations for mongodb
I'm voting to close this question as off-topic because this question is inappropriate for dba.se
Mar
2
comment What is a Key/Value store database?
The fact that there are often only two (or three, or a few more, depending on the metadata involved) columns instead of a massive number of columns, and the types are often fixed. There's no reason NOT to create a KVP store in a traditional RDBMS, except that it's basically schemaless.
Feb
11
awarded  Nice Question
Jan
5
awarded  Yearling
Dec
8
awarded  Popular Question
Nov
3
awarded  Good Question
Oct
25
comment Don't know how to transform variable entity into relational table
I would also suggest that breed is an attribute that all animals share, just in different ways.
Oct
21
comment Retrieving month from date field in my database
@Serg how often do you find yourself writing queries to do things that have no user interaction? What if the user were able to supply a given month and year, instead of us taking the current month and year from curdate()? I think that we should contemplate how to provide a parameterized query to find the data the user wants, and then as Aaron indicated, help the user figure out how to apply indexes to best give us the data quickly, so we don't have to do table scans.
Oct
21
comment Retrieving month from date field in my database
@Serg you may want to re-read the question and contemplate your answer, and possibly give more details on how this would be used, and what the value you've done above actually does in response to a UI selection of month and date.
Oct
21
comment Retrieving month from date field in my database
@ypercube sure it does. It just doesn't let the user select the actual month they want. What OP needs is a clear stored procedure that does basic TSQL (which means this is an SO Q) but what this answer offers is a RAD approach designed to indicate quickly in a demo how the product should work and as such I consider the informality of this post quite the avant garde expression for how little effort would go into such a query. I can definitely understand the delicate cycle of decision that led to this new poster on our site sharing such a simple selection, and allowing us to infer the obvious
Oct
17
awarded  Popular Question
Oct
13
comment Write filename, servername/IP and date+time in spool file
Hi will and thanks for the answer, but could you add a bit of explanation for those who don't speak PLSQL natively? This answer looks spammish to some of our readers because they don't understand what you're encouraging Jorge to do!
Sep
30
awarded  Explainer
Aug
28
revised Memory Issue - SQL Server 2008r2
deleted 27027 characters in body
Aug
13
revised Query for row combine
added 534 characters in body
Aug
5
comment Invalid date format in SSIS
@user3793534 when the answer proves to be your solution, you should check the checkmark underneath the votes on the left-hand side. We can provide further details if you need more assistance. Thank you.
Aug
5
revised VBA Maximize Access Application Main Window
added 28 characters in body
Aug
5
comment VBA Maximize Access Application Main Window
@MattyZDBA you should likely post that as the answer, as nothing else seems to have occurred here and that seems to have been the solution
Aug
5
revised Deny permissions for master in SQL Server
edited tags