Rob Farley

Adelaide, Australia

lobsterpot.com.au

Owner / Principal at LobsterPot Solutions

Adelaide (Australia) based SQL MVP

On twitter @rob_farley

Blog at http://sqlblog.com/blogs/rob_farley
(Old blog at http://msmvps.com/blogs/robfarley)

top accounts reputation activity favorites subscriptions

Electorate, Pundit, etc badge progress

feature-request badges electorate-badge reputation-cap-badges asked Jan 4 '10 at 1:58

meta.stackoverflow.com

37 votes

Can “user profile views” NOT include narcissism please?

feature-request bug status-completed views profile-page asked Aug 6 '09 at 6:18

meta.stackoverflow.com

34 votes

Inconsistent consecutive days

bug status-completed consecutive-days asked Jun 23 '10 at 3:48

meta.stackoverflow.com

13 votes

Better definition of Generalist badge

feature-request status-completed badges generalist asked Aug 17 '09 at 2:41

meta.stackoverflow.com

12 votes

Vote change on ANSWER if QUESTION is edited

feature-request revisions change-vote asked Jan 4 '10 at 4:00

meta.stackoverflow.com

11 votes

Does “user profile views” include narcissism?

discussion bug status-bydesign views asked Aug 6 '09 at 0:52

meta.stackoverflow.com

11 votes

Can we have “new functionality” icons?

feature-request help feature-list asked Aug 14 '09 at 0:42

meta.stackoverflow.com

7 votes

How do I get SQL Server to release its memory?

windows sql-server memory asked Feb 1 '10 at 5:29

serverfault.com

5 votes

I'm not human if I'm using my mobile

feature-request mobile asked Aug 7 '09 at 0:51

meta.stackoverflow.com

5 votes

Most recent votes

feature-request recent-activity voting asked Jan 4 '10 at 3:43

meta.stackoverflow.com

Top Answers

125

SQL to determine minimum sequential days of access?

stackoverflow.com

What can we learn from Quora?

meta.stackoverflow.com

Trim last 4 characters from string?

stackoverflow.com

Custom ORDER BY to ignore 'the'

stackoverflow.com

Should I use SQL JOIN or IN Clause?

dba.stackexchange.com

sql query to get content older than 3 weeks

stackoverflow.com

UNIQUE - way to have unique rows in table?

stackoverflow.com

Subquery returns more than one row SQL

stackoverflow.com

Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous

stackoverflow.com

What are your most common sql optimizations?

stackoverflow.com

SQL LIKE Performance with only the wildcard (%) as a value

stackoverflow.com

Using PIVOT in SQL Server 2008

stackoverflow.com

Stack Overflow taking down the evil Hyphen Site

meta.stackoverflow.com

Consecutive Day Count in profile

meta.stackoverflow.com

deleting databases in sql server

stackoverflow.com

Can “user profile views” NOT include narcissism please?

meta.stackoverflow.com

SQL Server Developer Edition versus SQL Server Standard

serverfault.com

SQL Query: Incrementing by two instead of 1

stackoverflow.com

How do you concat multiple rows into one column in SQL Server?

stackoverflow.com

Get a list of dates between two dates using a function

stackoverflow.com

Procedurally transform subquery into join

stackoverflow.com

TSQL foreign keys on views?

stackoverflow.com

SQL UDF in WHERE condition

stackoverflow.com

What do you expect of an 'Experienced Developer'?

stackoverflow.com

I want to see who marked my questions as favorites

meta.stackoverflow.com

Extra tables are added when I create a new Database

dba.stackexchange.com

How do you use MAXDOP in a View?

dba.stackexchange.com

Tables with no Primary Key

dba.stackexchange.com

Examples of great looking SSRS pdf reports

stackoverflow.com

Help with PIVOT

stackoverflow.com