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.


Sep
10
revised if block fails to create temp table in a procedure
added 644 characters in body
Sep
10
revised if block fails to create temp table in a procedure
added 644 characters in body
Sep
10
asked if block fails to create temp table in a procedure
Sep
5
comment Query does not use index when selecting all records
@FireExit #2.1 Why are you concerned with an index being used if you're migrating to a new database? Are you planning on doing a migration every 30 minutes?
Sep
5
comment Query does not use index when selecting all records
+1 for point #1
Aug
27
accepted Dynamic file name for file import
Aug
27
revised Dynamic file name for file import
code formatting
Aug
27
suggested suggested edit on Dynamic file name for file import
Aug
27
asked Dynamic file name for file import
Aug
22
comment How to make SSMS upper case keywords
@DavidFolksman Have you tried using GROUP BY with a SELECT *?
Aug
10
awarded  Yearling
Jul
19
comment Speeding up a NOT IN subquery
Please post the EXPLAIN
Jul
18
comment function hangs with null case operation
I'm on 2008R2; when I get to Choose Schemas, dbo is not listed. Just other schemas that I don't use.
Jul
18
accepted function hangs with null case operation
Jul
17
comment function hangs with null case operation
"do you have a very high proportion of NULL values in the Date column in that table?" I don't have NULL values for dates in any of those tables.
Jul
17
comment function hangs with null case operation
@MartinSmith Thanks for taking the time to examine them. Very insightful.
Jul
17
awarded  Self-Learner
Jul
17
comment function hangs with null case operation
@MartinSmith Updated with XML plans.
Jul
17
revised function hangs with null case operation
added 4004 characters in body
Jul
17
revised function hangs with null case operation
added 220 characters in body