20,380 reputation
459112
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 7 months
seen 2 hours ago

12h
reviewed No Action Needed PostgreSQL procedural languages overhead (plpython / plsql / pllua…)
13h
reviewed No Action Needed Why does this query take 32 sec to execute?
13h
reviewed No Action Needed MDF/TempDB Growth, SQL Server 2005 Enterprise
17h
reviewed Leave Open SQLCMD.exe in SQL Server 2012 does not give real-time output logging
17h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
deleted 10 characters in body
1d
reviewed Leave Open T-SQL Parsing XML escaped in format %3E (less than)
1d
reviewed Close Getting error creating database in SQL Server 2005
1d
answered Why would I not specify ROWLOCK to get rid of page locks?
1d
reviewed No Action Needed What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration?
1d
reviewed No Action Needed How to import large sql file in postgres?
1d
reviewed No Action Needed Slow Query with LIMIT
2d
comment Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
Try adding the query hint OPTION (FAST 10000)
2d
reviewed Close The most important oracle database performance metrics
2d
reviewed Close “DISTINCT” JOIN in mySQL
2d
reviewed Leave Open How to use SQLite3 in VB.Net 2013
2d
reviewed Approve suggested edit on Does the SQL Server backup process use a buffer cache?
2d
reviewed Leave Open One field with multiple values?
2d
reviewed Close I cannot add oracle listener with windows server 2008 r2
2d
reviewed Close SQL Server stuck in single_user with auto_update_statistics_async on
2d
reviewed Close SQL Server database performance is very poor after a month of use