Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
Rob Farley
  • Member for 10 years, 7 months
  • Last seen this week
Profile Activity
Stats
15,961
reputation
1.6m
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
36
silver badges
61
bronze badges
Top tags
View all tags
1,124
Score
256
Posts
81
Posts %
240
Score
47
Posts
15
Posts %
163
Score
33
Posts
10
Posts %
156
Score
29
Posts
9
Posts %
143
Score
22
Posts
7
Posts %
132
Score
32
Posts
10
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
82
Retrieving n rows per group
Dec 22, 2014
answer
32
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
26
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
19
What's better/faster? MySql or FileSystem?
Aug 25, 2012
answer
16
Fill in missing dates with data value from previous populated date for group
May 17, 2016
answer
14
How to get exact year difference between two dates in SQL Server?
Jul 25, 2015
answer
14
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
209
How do I return rows with a specific value first?
149
SQL to determine minimum sequential days of access?
114
Electorate, Pundit, etc badge progress
102
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?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.