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

Feb
5
revised Maintaining Referential Integrity with a Filestream enabled database
formatting
Feb
1
revised How is SQL Server returning both a new value and old value during an UPDATE?
Added example of other effects at read committed
Jan
15
revised How much RAM should you allocate a MySQL replication slave?
Formatting, incorporated second answer.
Jan
15
revised MySQL: How to drop all tables starting with a prefix?
Formatted code (using CTRL+K - you can also use the toolbar icon)
Jan
12
revised Which items are table entities and which are fields?
formatting
Jan
12
revised Suppressing the SSMS prompt to save changes
deleted 66 characters in body; edited tags; edited title
Jan
11
revised Tablespace utilization in db2 (percentage of tablespaces)
Formatting
Dec
27
revised MySQL Performance Monitoring
added and improved links
Dec
23
revised What are the low-level storage requirements?
Minor typos, added link to white papers
Dec
16
revised Shard key selection for both write scaling and query isolation?
improvements to title and body readability
Dec
15
revised Does RCSI use less or same space than SNAPSHOT? Why?
Emphasis, feel free to rollback if you disagree
Dec
14
revised How to move from 32bit SQL Server install to 64bit?
added 196 characters in body
Dec
14
revised Permissions Needed To Attach AdventureWorks Database
Incorporated author's link from comments
Dec
14
revised Permissions Needed To Attach AdventureWorks Database
edited tags; edited title
Dec
14
revised Unexpected EOF during bulk insert
edited tags; edited title
Dec
14
revised Why do row-versioning isolations use a linked list of versions of record?
added 1 characters in body; edited title
Dec
14
revised Script all tables in a database
deleted 15 characters in body; edited tags; edited title
Dec
14
revised How do I identify the column(s) responsible for “String or binary data would be truncated.”
Removed unnecessary text
Dec
14
revised Can a single PostgreSQL query use multiple cores?
added 1 characters in body; edited tags; edited title
Dec
14
revised How many blocks is my database
added 10 characters in body