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.


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?
Sep
12
comment SSRS partial printing issue
@bluefeet IIRC There have been more trees replaced than are being cut down for printing. So print away!
Sep
11
comment if block fails to create temp table in a procedure
If I read this correctly, I should continue to check and drop any ## tables used in my procedure?
Sep
11
comment if block fails to create temp table in a procedure
@SebastianMeine Did not know. Very useful information. Will definitely practice this going forward. Does going out of scope also apply for ## tables?
Sep
10
revised if block fails to create temp table in a procedure
added 15 characters in body; edited title
Sep
10
answered if block fails to create temp table in a procedure
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