21,484 reputation
761126
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 1 hour ago

2d
reviewed Reviewed Reasons for avoiding large ID values
2d
revised Reasons for avoiding large ID values
edited tags
2d
reviewed No Action Needed mysqld got signal 11 - it's my fault but how do I fix it?
2d
reviewed Close CodePlex: SQL Server Partition Management Tool
2d
reviewed Leave Closed Server CPU usage Issue
Dec
23
reviewed Approve CodePlex: SQL Server Partition Management Tool
Dec
23
revised How to find the SQL statements that caused tempdb growth?
Copy edit
Dec
23
revised MySQL - Alter table to automatically put in a UUID
added 4 characters in body
Dec
23
revised Effects of turning the transaction safety OFF
edited tags
Dec
23
reviewed Reviewed MySQL - Alter table to automatically put in a UUID
Dec
23
comment use an Index correctly to optimize queries
Table partitioning is in preview link1 link2 but I doubt it's the right solution here. As you say at the start of your answer, the ntext columns need to go. I doubt they store > 8000 bytes anyway. The OP appears to be quite new to databases.
Dec
23
revised use an Index correctly to optimize queries
edited tags
Dec
23
reviewed Close Incorrect syntax near the keyword 'AS'
Dec
23
reviewed Reviewed Is it advantageous to scale out using multiple SQL Server instances on the same server?
Dec
23
reviewed No Action Needed Minimizing database size (Many small tables)
Dec
23
reviewed Reviewed Error APP-AR-294094: An Unexpected error has occurred
Dec
23
reviewed No Action Needed Multi-row insert vs multiple single row inserts
Dec
23
revised Multi-row insert vs multiple single row inserts
In-lined link, corrected typos, removed intro.
Dec
22
reviewed Close Use LDAP for name look up with Oracle Instant Client
Dec
22
reviewed Close SELECT returning NULL always