Reputation
704
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 18
Impact
~11k people reached

Jul
22
comment Why does the Tuple Mover in C-Store consider only rows older than LWM?
@JayDee The first part of the epoch values being used for movement is correct. The second part can also be true.
Jun
14
comment Pairwise intersections
@AndrisBirkmanis Vertica uses ANSI SQL. How more generic can you get?
Apr
14
comment SQL Job to be run earlier on last work day of month
+1 for expedited response
Apr
14
comment SQL Job to be run earlier on last work day of month
@AaronBertrand Can you please expedite JCBWS's request?
Oct
3
comment How to query from a linked server via a linked server in sql server?
@kaptan Next time you go to the mechanic, and they ask what's wrong, don't give them any explanations.
Sep
17
comment Keeping rows ordered by counter value
@MaxVernon What's the point of storing relational data in a relational database system?
Sep
1
comment How to architect an analytical BI platform?
You can try browsing around vertica.com or third party vendors for white papers or use cases. If you choose Vertica, architecture could be part of the work. In regards to your earlier comment, I'm pretty sure Vertica has a much lower cost of ownership than other EDW. Feel free to reach out privately (send me a message at vertica.tips) and we can discuss further.
Aug
27
comment Proposal: MySQL blob handling revision
GIVE IT A TRY!!! ... there, now your answer is perfect.
Jun
20
comment Where do I find the tables that a role has access to in Vertica?
But you said you "poked around" in the GRANTS table...
Jun
19
comment Where do I find the tables that a role has access to in Vertica?
What is your desired result? This may help
Jun
2
comment Innodb: Operating System Error number 5 in MySQL
Off-topic and belongs on Database Administrators
May
28
comment Is there better way to design SQL tables
I think the ReceivedOrder, HoldOrder, DispatchOrder could be combined.
Mar
11
comment Database software advice
@Jason Perhaps you're not being clear about what you need and blindly going with some less-than-optimal solution.
Mar
5
comment Ola Hallengren with database mirroring
@swasheck Speak for yourself, but I was more excited than a little school girl.
Mar
4
comment Ola Hallengren with database mirroring
Can someone verify the authenticity of this user?
Feb
19
comment Which of these two queries is better - can be optimized more?
I doubt you'll get a general consensus. Too much is "it depends." You may want to add those types of things (EXPLAIN statements) to your question.
Feb
19
comment Which of these two queries is better - can be optimized more?
Have you looked at the EXPLAIN statement for both?
Feb
5
comment Why bulk loading a Vertica database table does not load all lines?
If you plan on answering your own questions, you may want to consider asking your question as a community wiki.
Jan
27
comment Column to Row and Vice Versa
What you're looking for is called a pivot; which is not easy with MySQL. I would recommend that you search Stack Overflow for similar issues and start there.
Jan
13
comment 24x7 vs Night Time Window
+1 very well written.