meta user
network profile
| bio | website | jadito.us |
|---|---|---|
| location | Chicago, IL | |
| age | 25 | |
| visits | member for | 9 months |
| seen | 3 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.
|
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 |
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 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 24 |
comment |
How to snapshot or version a relational database when data changes? This question belongs on dba.se |
|
Apr 21 |
comment |
Simple MySQL query randomly takes forever How do you know one doesn't already exist? |
|
Apr 21 |
comment |
Simple MySQL query randomly takes forever Please update your question with the EXPLAIN and structure |
|
Apr 17 |
comment |
How to permanently delete a row in oracle forever Sounds like you're trying to hide something? |
|
Apr 9 |
comment |
mySql Relationships / Index - Checking for duplicates An algorithm where? |
|
Apr 9 |
comment |
SQL Application Role access-control This is off topic and belongs on dba.se |
|
Apr 4 |
comment |
SSIS keeps force changing excel source string to float Since when is 323.2 a string? |
|
Mar 28 |
comment |
Which database could handle storage of billions/trillions of records? Is this for the NSA or something? |
|
Mar 26 |
comment |
InnoDB best index practises Your best bet would be to evaluate the queries that are being performed and create (possibly composite) indexes best on high traffic queries. |
|
Mar 22 |
comment |
MySQL - run SELECT statement on another server without defining the table structure possible duplicate of How to create linked server MySQL |
|
Mar 21 |
comment |
Does MySQL Replication hamper the performance of my DB? It does but the question has more to do with DBA then software development. |
