| bio | website | ta.speot.is |
|---|---|---|
| location | Brisbane, Australia | |
| age | 23 | |
| visits | member for | 2 years, 2 months |
| seen | Jun 11 at 3:55 | |
| stats | profile views | 14 |
I try to share knowledge of the arcane on my blog - I invite you to check it out.
|
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? |