Database Administrators
Meta user
Network profile
14,323
reputation
1
29
52

Rob Farley

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)

291
answers
0
questions
~1.2m
people reached
  • Adelaide, Australia
  • lobsterpot.com.au
  • Member for 8 years, 4 months
  • 794 profile views
  • Last seen 35 mins ago

Communities (10)

Top Meta Posts
2
0

Top network posts

Top tags (145)

Score 987
Posts 232
Posts % 80
Score 233
Posts 46
Score 157
Posts 33
Score 137
Posts 26
Score 124
Posts 21
Score 117
Posts 30
View all tags →

Top posts (291) All Questions Answers | Votes Newest

73 Retrieving n rows per group Dec 22 '14
29 Why does adding a TOP 1 dramatically worsen performance? Jan 29 '16
25 IF EXISTS taking longer than embedded select statement Jan 14 '16
25 Best practice between using LEFT JOIN or NOT EXISTS Nov 14 '15
22 How to remove line breaks in SSMS? Dec 31 '15
18 Returning a result set with multiple rows based on max date Apr 30 '12
16 What's better/faster? MySql or FileSystem? Aug 25 '12
14 Should I use SQL JOIN or IN Clause? Oct 29 '11
14 Fill in missing dates with data value from previous populated date for group May 17 '16
13 How to get exact year difference between two dates in SQL Server? Jul 25 '15
View all questions and answers →

Badges (82)

Gold

1

Rarest

Silver

29

Rarest

Bronze

52

Rarest

View all badges →