Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Newest
 Critic
Impact
~7k people reached

Jul
25
comment Multi-threaded inserts vs serial
It is one write head on the other end (unless you have something fancy like partitioning).
Jul
15
comment Effective indexing and querying of overlapping date/time ranges
Looks like a good index to me. Load some data and look at the query plan.
Jul
15
comment Query does not use index (according to EXPLAIN SELECT)
Why would you include pid in the PK?
Jul
15
comment Why is ORDER BY LIMIT 1 so much faster than MAX?
This makes not sense to me. I know it can use that index, because I can force it, but I suspect it's ignoring the sts_in part of it and just searching by user id. If the give the same answer they are searching the same stuff.
Jul
15
revised Why is ORDER BY LIMIT 1 so much faster than MAX?
general formatting for readability
Jul
15
suggested approved edit on Why is ORDER BY LIMIT 1 so much faster than MAX?
Jul
15
comment prioritize one query over the other in mysql
But if the transaction for t1 is small then what is the big deal with just letting the transaction finish. A rollback could take as long as a commit and then t1 has to start over. Have small transactions and small locks on T1.
Jul
15
answered Do I want an index if all I care to query is field not null
Jul
15
comment prioritize one query over the other in mysql
Update the question. And put a ? mark in the question.
Jul
15
comment SQL Server Slowdown?
A reach but fragmentation of the disk that hold the database and log files. Are you possibly on a RAID 5 in a degraded mode.
Jul
14
comment Shrink database or DB files not reducing size although I dropped biggest table
Review the options you used on SHRINKDATABASE and SHRINKFILE
Jul
12
comment Is it ok to create additional column for helping other column to be a PK?
Why allow a user to repeat a nickname and age?
Jul
12
comment Is it ok to create additional column for helping other column to be a PK?
oracle or sql-server
Jul
10
awarded  Critic
Jul
9
answered sqlldr running slow after indexes created
Jul
9
comment Timestamp-based index
You miss a Reason for: Space. Clustered index does not use space. Maybe that is what you mean by big amount of data. I have read that a clustered index can be a little faster.
Jul
9
comment Is a normalized MYSQL DB faster than one organized with comma strings?
Normalization is pretty much the accepted best practice. Don't fret over speed.
Jul
9
awarded  Citizen Patrol
Jun
19
answered TSQL insert table using view — performance issue
Jun
19
comment TSQL insert table using view — performance issue
One that join on P2 kill the left join on P. Pull the conditions in the where up into the join