Skip to main content
Database Administrators
Rob Farley's user avatar
Rob Farley's user avatar
Rob Farley's user avatar
Rob Farley
  • Member for 12 years, 10 months
  • Last seen more than a week ago
Profile Activity
Stats
16,229
reputation
2.0m
reached
315
answers
0
questions
Communities
View all
About

Owner / Principal at LobsterPot Solutions

Adelaide (Australia) based SQL MVP

On twitter @rob_farley

Blog at http://blogs.lobsterpot.com.au

Badges
View all badges
2
gold badges
38
silver badges
61
bronze badges
Top tags
View all tags
1,150
Score
256
Posts
81
Posts %
228
Score
46
Posts
15
Posts %
167
Score
33
Posts
10
Posts %
156
Score
29
Posts
9
Posts %
147
Score
22
Posts
7
Posts %
132
Score
31
Posts
10
Posts %
Top posts
View all questions and answers
answer
86
Retrieving n rows per group
Dec 22, 2014
answer
41
Best practice between using LEFT JOIN or NOT EXISTS
Nov 14, 2015
answer
29
Why does adding a TOP 1 dramatically worsen performance?
Jan 29, 2016
answer
27
How to remove line breaks in SSMS?
Dec 31, 2015
answer
25
IF EXISTS taking longer than embedded select statement
Jan 14, 2016
answer
20
Returning a result set with multiple rows based on max date
Apr 30, 2012
answer
20
What's better/faster? MySql or FileSystem?
Aug 25, 2012
answer
17
How to get exact year difference between two dates in SQL Server?
Jul 25, 2015
answer
16
Fill in missing dates with data value from previous populated date for group
May 17, 2016
answer
13
Should I use SQL JOIN or IN Clause?
Oct 29, 2011
Top Meta posts
2
0
4
Meta-meta. Why Meta.DBA?
Top network posts
View all network posts
219
How do I return rows with a specific value first?
150
SQL to determine minimum sequential days of access?
118
Electorate, Pundit, etc badge progress
108
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous
99
What can we learn from Quora?