Reputation
298
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 12
Newest
 Revival
Impact
~8k people reached

1d
answered Best database to store and retrieve Word and Excel documents
2d
revised Why does my query search datetime not match?
added 8 characters in body
2d
awarded  Revival
Sep
2
revised Why does my query search datetime not match?
added 3 characters in body
Sep
2
revised Why does my query search datetime not match?
added 62 characters in body
Sep
2
revised Why does my query search datetime not match?
added 144 characters in body
Sep
2
answered Why does my query search datetime not match?
Aug
20
revised Index tuning question
added 354 characters in body
Aug
20
answered Index tuning question
Aug
10
awarded  Yearling
Aug
10
comment Increase SQL Server Performance
Good for you - you got fragmentation. Really identity was causing threads to block?
Aug
9
comment Increase SQL Server Performance
@ShawnMelton stackoverflow.com/questions/11938044/…
Aug
9
revised Increase SQL Server Performance
added 66 characters in body
Aug
9
comment Increase SQL Server Performance
Come down vote what is the problem?
Aug
9
answered Increase SQL Server Performance
Aug
4
comment MySQL IN() statements: Avoiding duplicate lists
Declaring a PK on tmp may help performance and insert in order of the the PK.
Aug
3
awarded  Caucus
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?