361 reputation
27
bio website ta.speot.is
location Brisbane, Australia
age 24
visits member for 3 years
seen Nov 25 '13 at 21:29

I try to share knowledge of the arcane on my blog - I invite you to check it out.


Oct
29
awarded  Commentator
Oct
29
comment Query Optimizing Request
Indexing the fields individually won't help as much as creating an index whose key is all three fields, or whose key and covering columns cover the three fields.
Oct
27
comment Query Optimizing Request
The clustered index scan on materials_progress suggests to me that there are no indexes on that table is for some combination job_id, line_no or component_name_id. You might need to index those fields in materials_progress. You might also have bad statistics.
Oct
27
comment Query Optimizing Request
What is the execution plan?
Oct
24
awarded  Supporter
Oct
24
comment Database 'MyDb' is being recovered. Waiting until recovery is finished
+1 for Auto-Close
Sep
17
comment MS Access / MySQL: unlock locked Records
It looks like Access does the locking. Related: stackoverflow.com/questions/12026199/…
Aug
20
comment Database is too large due to appended backup
See Remarks here
Aug
20
comment Database is too large due to appended backup
Shrinks the database... You might have heard it referred to as evil because it can cause a lot of index fragmentation.
Aug
20
comment Database is too large due to appended backup
Shrink the database.
Jun
8
awarded  Caucus
Mar
29
awarded  Yearling
Mar
19
comment SQL query slow-down from 1 second to 11 minutes - why?
I checked out the execution plan for your main query and f*ck me, it's a mess. oi41.tinypic.com/2zz0q41.jpg I think that's your problem.
Feb
25
awarded  Autobiographer
Jul
19
comment SQL Server 2008 Index
Also, make sure you have FK constraints on a.pr_number, b.br_number and c.pr_number (if appropriate). It can speed lookups.
Mar
29
comment SQL Server 2008 R2 Express for a single website?
The setup process for SQL Server 2005 Express somewhat fragile. Newer versions are more robust. You should install SQL Server Express and see how it goes.
Mar
29
comment SQL Server 2008 R2 Ent trial expired move to express?
Are they two different instances? You need to specify the correct instance name when you connect to them, they aren't amalgamated into one.
Mar
29
answered SQL Server 2008 R2 Express for a single website?
Mar
29
awarded  Teacher
Mar
29
answered SQL Server 2008 R2 Ent trial expired move to express?