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

9h
reviewed Leave Open T-SQL Parsing XML escaped in format %3E (less than)
9h
reviewed Close Getting error creating database in SQL Server 2005
9h
reviewed Delete Disabled SSL on SQL Server, now connection fails
9h
answered Why would I not specify ROWLOCK to get rid of page locks?
22h
reviewed No Action Needed What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration?
22h
reviewed No Action Needed How to import large sql file in postgres?
22h
reviewed No Action Needed Slow Query with LIMIT
1d
comment Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
Try adding the query hint OPTION (FAST 10000)
1d
reviewed Close The most important oracle database performance metrics
1d
reviewed Close “DISTINCT” JOIN in mySQL
1d
reviewed Leave Open How to use SQLite3 in VB.Net 2013
1d
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
2d
reviewed Close Are there any minimal sqlite extensions for running a server with role based access control?
2d
reviewed Leave Open SQL Server Performance
2d
comment SQL Server Performance
Perhaps. 2GB might be enough to hold the data and index pages, but extra memory can be used for other purposes e.g. caching execution plans and sorting/hashing.
2d
reviewed No Action Needed Why the operation is not rolled back?