FreshPrinceOfSO

less info
meta site favicon meta user | stack exchange network profile network profile
288 reputation
213
bio website jadito.us
location Chicago, IL
age 25
visits member for 9 months
seen 17 hours ago
stats profile views 97

I am 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.

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.


77 Actions

suggestions reviews revisions comments badges posts accepts all
2d
 awarded  Constituent
May
15
 comment Can I use the database and query it while full-text indexing?
This question/answer should help.
May
15
 comment Can I use the database and query it while full-text indexing?
Can you park a car while driving 90 km/h?
May
15
 comment Is it better to use AUTOCOMMIT = 0
After the entire INSERT is completed.
May
15
 answered Is it better to use AUTOCOMMIT = 0
May
15
 comment skip columns while using LOAD command mysql
This is covered in the documentation
May
15
 comment Cannot connect to SQL Server after setting sa password to blank
+1 for picktures
May
14
 accepted Writing a database analysis document
May
14
 accepted Workaround to importing data
May
14
 awarded  Scholar
May
14
 accepted Best practice for copying tables from server to server
May
14
 awarded  Caucus
May
13
 comment Database Volume Statistics in Oracle - dba_hist_tbspc_space_usage
Off topic; belongs on dba.se
Apr
26
 comment How to design database table to store process status?
You can also do replication.
Apr
26
 comment How to design database table to store process status?
What do you mean it will be queried frequently? As in there will be records inserted or there will be selects hitting the table?
Apr
26
 comment How to design database table to store process status?
My only reservation about a stopTimestamp is being able to a) find that record, b) inserts are quicker
Apr
26
 answered How to design database table to store process status?
Apr
25
 revised best relationship for this design?
title, body, tags
Apr
25
 suggested suggested edit on best relationship for this design?
Apr
25
 answered best relationship for this design?
1 2 3 4