351 reputation
16
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?