15,576 reputation
44693
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 month
seen 6 hours ago

Dec
14
revised Error ORA-06550
edited title
Dec
14
revised Move data from one table to another
deleted 5 characters in body; edited tags; edited title
Dec
13
revised Does Oracle 10g Express Edition have enough storage?
deleted 33 characters in body; edited tags; edited title
Dec
13
revised numbering rows consecutively for a number of tables
added 1 characters in body; edited tags; edited title
Dec
13
revised Why use WHERE 1 or WHERE 1=1?
Improve title, grammar, and formatting
Dec
13
revised PL/SQL: best way to count elements in an array?
Use CTRL-K or the {} button to format code
Dec
8
revised What is the ideal connection pool size for RDS MYSQL?
Typo in title
Dec
5
revised Why does SQL Server require the datatype length to be the same when using UNPIVOT?
added 109 characters in body
Dec
5
revised Why does SQL Server require the datatype length to be the same when using UNPIVOT?
added 180 characters in body
Dec
5
revised Why does SQL Server require the datatype length to be the same when using UNPIVOT?
deleted 2 characters in body
Dec
5
revised ORACLE error while dbstart command
Improved spelling and grammar; removed superfluous text
Dec
4
revised Backup everything except one record
Removed tag in title; minor grammar and formatting
Nov
5
revised Squeezing Maximum Out Of My Server
added 34 characters in body; edited tags
Nov
1
revised Fastest way to perform simple operations on 1 million rows
deleted 191 characters in body; edited tags; edited title
Oct
31
revised Index not making execution faster, and in some cases is slowing down the query. Why is it so?
deleted 1 characters in body
Oct
31
revised Index not making execution faster, and in some cases is slowing down the query. Why is it so?
added 233 characters in body
Oct
30
revised Syntax of INNER JOIN nested inside OUTER JOIN vs. query results
added 283 characters in body
Oct
29
revised How to select single value from first column and all the values from remaining columns?
added 25 characters in body
Oct
29
revised GROUP BY with MAX versus just MAX
Fixed column reference
Sep
30
revised Backup and restore FileTable files
added 52 characters in body; edited tags; edited title