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

Aug
2
reviewed No Action Needed Can't backup a Postgres database: FATAL: Peer authentication failed for user “postgres”
Aug
1
reviewed No Action Needed Casting fails on subquery result
Aug
1
reviewed No Action Needed Formatting T-SQL in SSMS 2012
Aug
1
comment Adding a sequence number to existing rows
It was Daniel's. I just made it look pretty and did the admin :)
Aug
1
revised Adding a sequence number to existing rows
deleted 71 characters in body; edited tags; edited title
Aug
1
revised Adding a sequence number to existing rows
added 1068 characters in body
Aug
1
reviewed Reviewed Create Meaningful Visualization for Large Set of Tables
Aug
1
comment Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Hi David. I'm not sure this adds much to araqnid's answer. Perhaps it would be better to delete this and simply mark the other answer as correct?
Aug
1
reviewed Close Can a connection's prepared statements be altered by Postgres's admin functionality?
Aug
1
reviewed Reopen How to move 200 materialized views without having to re-create in the new home
Jul
31
revised Execute T-SQL Only If AlwaysOn Database Is Primary
Improved title, formatting, and tags
Jul
31
reviewed Reviewed SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?
Jul
31
reviewed Edit Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Jul
31
revised Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Formatting
Jul
31
comment CROSS APPLY giving 'incorrect syntax' error on one SQL Server 2008 R2 database, with compat level = 100?
The compatibility level that is important is that of the context database not the target database. Check that the 'current database' for the connection (set using USE or by being the default for the login etc.) is not compat level 80.
Jul
31
comment Removing a string prefix
In that case RIGHT(@s,LEN(@s)-PATINDEX('%00[^0]%',@s)-1) would also work.
Jul
31
reviewed Reviewed Query for frequency of e-mail addresses in a field
Jul
31
reviewed Reviewed Removing a string prefix
Jul
31
revised Removing a string prefix
deleted 24 characters in body; edited tags; edited title
Jul
31
reviewed No Action Needed How to create an oracle dump(.dmp) file using Toad?