507 reputation
315
bio website jadito.us
location Chicago, IL
age 26
visits member for 1 year, 8 months
seen Apr 11 at 19:31

Currently I am a Jr. Database Administrator and formerly 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
21
comment Does restoring database clear buffer cache and stored proc cache
Your screenshots aren't pretty, but here's an upvote.
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
+1 learned something today
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
If you're restoring from a backup, then I don't believe it does. I could be wrong and will happily hear why.
Nov
20
comment SQL Server log file continues to grow?
While link answers are helpful, it's beneficial to point the OP to the specific part of the link, or even include it in your answer.
Nov
20
comment SQL Server log file continues to grow?
This question belongs on Database Administrators
Nov
5
comment Make “as” mandatory when create column alias?
Not possible. The only way to enforce this is by nagging the people who write the code.
Nov
5
comment How do you see which database on a Server uses most resources
You should blog about this.
Nov
5
comment Why are we suddenly getting time-outs on multiple transactions?
Space available: 1.93MB ... Add more floppy's.
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