20,867 reputation
459113
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 8 months
seen 1 hour ago

Aug
5
answered Update on view over partitioned tables updating all indexes
Aug
5
reviewed No Action Needed score ranking no tie, if tie order by score submit date
Aug
5
reviewed Looks OK After issuing an Insert using NewId() can you get the Ids that were used in that Insert
Aug
5
reviewed No Action Needed Is there a way to replicate Postgres databases in Amazon RDS between regions?
Aug
4
reviewed Leave Closed Transferring Data from SQL Server to SQL Server Express?
Aug
4
reviewed Approve suggested edit on How to insert (file) data into a PostgreSQL bytea column
Aug
4
reviewed Approve suggested edit on sql-server-2005 tag wiki
Aug
4
reviewed Approve suggested edit on sql-server-2005 tag wiki excerpt
Aug
4
reviewed Approve suggested edit on sql-server-2012 tag wiki
Aug
4
reviewed Approve suggested edit on sql-server-2012 tag wiki excerpt
Aug
4
comment Update on view over partitioned tables updating all indexes
What plan do you get if you add OPTION (RECOMPILE) to the UPDATE query?
Aug
4
reviewed Approve suggested edit on SQL Server Agents Jobs failed when executed on schedule but succeeds when executed manually
Aug
4
reviewed Close All MySQL databases are unavailable because of a broken table
Aug
4
reviewed Leave Open SQL Server : what licence is required?
Aug
4
reviewed Looks OK How to manage MySQL database with Oracle Fusion Middleware?
Aug
4
reviewed Reviewed Temporarily splitting a SQL Server cluster
Aug
4
reviewed Approve suggested edit on Trying to create PostGIS database
Aug
4
reviewed Reviewed Should all machines which run mongo instances (mongod or mongos) in a Mongo DB cluster have unique hostnames (also at OS level)?
Aug
4
revised Side effects of using updlock lock hint?
deleted 210 characters in body
Aug
4
revised Side effects of using updlock lock hint?
Corrected a rather crucial word