23,747 reputation
873144
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 4 years
seen 16 mins ago

Jan
18
revised Getting 0KB of size file while backup mysql database using mysql dump
Incorporated comment in answer; fixed code formatting
Jan
18
revised ER diagram to tables
Improved title, formatting, incorporated clarification in comment
Jan
16
revised Deadlock due to concurrent updates (with SIU lock)
added 109 characters in body
Jan
16
revised Deadlock due to concurrent updates (with SIU lock)
Improved title, formatting, and tags
Jan
16
revised Deadlock due to concurrent updates (with SIU lock)
added 367 characters in body
Jan
16
revised Deadlock due to concurrent updates (with SIU lock)
added 37 characters in body
Jan
16
revised Deadlock due to concurrent updates (with SIU lock)
added 37 characters in body
Jan
16
revised postgresql wiki description
deleted 21 characters in body
Jan
16
revised postgresql wiki excerpt
deleted 3 characters in body
Jan
16
revised Is it possible to emulate the WITH command in MySQL 5.1.73?
Removed horizontal scroll bar from code for improved readabiliy; added cte tag
Jan
16
revised Linked Server Security under SQL Agent Job Context
Formatting
Jan
14
revised Error when using views on a linked server
deleted 7 characters in body
Jan
14
revised Error when using views on a linked server
Clarified what "compile but don't execute" means
Jan
14
revised reporting space consumption to files in filegroup - how to reverse-engineer the algorithm spreading data across files
Incorporated useful information from the question comments to make this more of an answer
Jan
14
revised MERGE a UNION query results down to one row per KEY value
edited tags
Jan
14
revised Error when using views on a linked server
Incorporated information from the comments
Jan
14
revised Error when using views on a linked server
Formatting, tags, copy edit
Jan
14
revised Allow public use of functions without giving them database control
edited tags
Jan
13
revised How to use a subquery that returns multiple rows?
Did what I can with the code formatting
Jan
13
revised Compatibility level when upgrading a SQL Server 2005 database to SQL Server 2012
Formatting