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

Feb
27
revised SSD vs HDD for databases
deleted 22 characters in body; edited title
Feb
27
revised Running total to the previous row
deleted 58 characters in body; edited tags; edited title
Feb
27
revised Spatial index not used
Spelling, layout, tags
Feb
26
revised Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2
Minor formatting/spelling, changes for conciseness, separated background info, retagged
Feb
25
revised Platform independent select ordered by primary key
Changed the deprecated `IDENTITYCOL` to `$IDENTITY`, added documentation link
Feb
24
revised Memcached plugin on MariaDB?
In-lined link
Feb
22
revised Grouping by date range in a column
deleted 109 characters in body; edited tags
Feb
22
revised Managing Transaction Log Size using a Maintenance Plan
edited tags; edited title
Feb
18
revised Change data capture - how to know who made the change?
Formatting (using CTRL+K or the menu option) and removed unnecessary opening text
Feb
14
revised Ask about Inner Join & Union
Use CTRL+K or the menu option to format code blocks
Feb
13
revised How do I copy databases from Postgres 8.4 to Postgres 9.1?
Minor formatting improvements; removed signature
Feb
13
revised Is replication possible on two different domains?
Formatting and spelling.
Feb
12
revised Single statement or batched delete?
added 1 characters in body; edited tags; edited title
Feb
11
revised Get the value of one attribute from the reference key of another table?
Improved formatting to remove the horizontal scroll bar
Feb
6
revised if-then-else gives a boolean headache
Formatting & readability
Feb
6
revised Alternatives for subquery
Formatting and readability
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)