587 reputation
416
bio website jadito.us
location Chicago, IL
age 27
visits member for 2 years, 1 month
seen 21 hours ago

Currently I am a Technical Consultant. 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.


Nov
4
comment Understanding Indexes and using them better
If I could only get rep for it.
Nov
4
comment Understanding Indexes and using them better
Use them to the MAX()!
Nov
1
accepted create linked server to vertica
Oct
31
revised create linked server to vertica
deleted 18 characters in body
Oct
31
comment Table Design Cardinality
I'm probably not fully taking into account your entire schema, however, there is nothing wrong with having flag columns that identify a user as a vendor or buyer.
Oct
31
answered Table Design Cardinality
Oct
30
answered create linked server to vertica
Oct
30
comment create linked server to vertica
@billinkc Verified that the 64-bit ODBC drivers are installed.
Oct
30
comment To Join two tables without using Primary key
The reason that you should be joining on a key is to increase the likelihood of an index being used.
Oct
30
asked create linked server to vertica
Oct
25
comment Easier way to change every user in every database to default schema = dbo?
You should make a blog post out of this.
Oct
9
asked calculate days and equally distribute remaining
Oct
2
comment How do you see which database on a Server uses most resources
This question is off-topic and belongs on Database Administrators
Sep
24
comment Increase all primary key values by 1
@PaulWhite Is there something you haven't discussed about SQL Server?
Sep
24
comment How to become a DBA…the non-standard route (not beginning as sysadmin or dev)?
Read Brent Ozar's How to Become a Database Administrator and Should I Specialize?
Sep
24
comment Upgrade SQL Server 2000 database to 2008 R2 and enable new features
Don't know what you're talking about. Have an upvote.
Sep
16
comment How can I prove that the following T-SQL is bad for performance?
Do you sleep Mr. Remus? Hat's off to your contributions here.
Sep
13
accepted if block fails to create temp table in a procedure
Sep
13
comment Query getting periodically stuck in 'copying to tmp table' state, never completes
Please post move your query into the question, and post the output from EXPLAIN.
Sep
12
comment SSRS partial printing issue
Is this being printed on a dot-matrix printer?