Database Administrators
Meta user
Network profile
14,103
reputation
1
26
51

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)

284
answers
0
questions
~1.1m
people reached
  • Adelaide, Australia
  • lobsterpot.com.au
  • Member for 7 years, 10 months
  • 767 profile views
  • Last seen 2 days ago

Communities (10)

Top Meta Posts
2
0

Top network posts

Top tags (145)

Score 967
Posts 225
Posts % 79
Score 155
Posts 33
Score 136
Posts 25
Score 120
Posts 21
Score 115
Posts 30
Score 108
Posts 22
View all tags →

Top posts (284) All Questions Answers | Votes Newest

69 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
23 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
12 Insert performance increases under load: Why? Feb 22 '16
View all questions and answers →

Badges (78)

Gold

1

Rarest

Silver

26

Rarest

Bronze

51

Rarest

View all badges →