557 reputation
316
bio website jadito.us
location Chicago, IL
age 27
visits member for 1 year, 11 months
seen Jul 15 at 21:50

Currently I am a consultant for HP's Vertica. Previously, I was a Jr. Database Administrator and before that, a SQL Server Database Programmer. My graduate research and studies are primarily involved with database models and optimization. I like to write on my blog about technical problems which I've encountered. Feedback is always welcome and appreciated.

I'm a Pastafarian and part of the Church of the Flying Spaghetti Monster.

Writing a question? Follow Jon Skeet's guide on how to write a good question.

Answering a question? Follow Jon Skeet's guide on how to write a good answer.


Jul
15
comment Output of sorting is different with same store procedure and data when running in different database environment,
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking.
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
4
comment Why Vertica not showing all data in the table after bulk load from SSIS?
Possible duplicate of Records getting rejected in HP Vertica While Copying
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
16
comment how to grant rollback privilege to user in mysql?
This question is off topic for Stack Overflow and belongs on Database Administrators
Jan
13
comment 24x7 vs Night Time Window
+1 very well written.
Jan
5
comment Is there a complete list of Online operations for each SQL Server version?
It seems like you're both speaking different languages.
Dec
26
comment SQL Server Stored Procedure - Does Raiserror affect performance
Have you tested it?
Dec
26
comment How to restore a database from the SQL 2008R2 log?
It's times like these that I finally understand why some DBMS are not auto-commit.
Dec
10
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
We're all going to scream that your DBA is a moron if that's all they said, but are you sure there wasn't other context to your DBA's argument?
Nov
27
comment Migration of MYSQL to MS SQL Server
How is this programming related?