network profile
| bio | website | ta.speot.is |
|---|---|---|
| location | Brisbane, Australia | |
| age | 23 | |
| visits | member for | 2 years, 1 month |
| seen | Feb 26 at 23:32 | |
| stats | profile views | 12 |
I try to share knowledge of the arcane on my blog - I invite you to check it out.
|
Apr 23 |
comment |
How to enhance the SQL query performance for thousands and millions of huge data You have more than one huge datas? I think you need MongoDB, I hear it's web-scale. |
|
Jan 26 |
comment |
Index included columns There's a difference, in your query SQL Server has to do much more work when inserting, updating and deleting data because it has to order by three columns instead of one. Timestamp by itself might be selective enough to filter out 90% of the results, how much data do you change? |
|
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? |
