User Rob Farley - Database Administrators Stack Exchange

Rob Farley

Member for 12 years, 1 month
Last seen more than a week ago

Twitter
lobsterpot.com.au
Adelaide, Australia

315 Answers

Score Activity Newest

86 votes

Accepted

Retrieving n rows per group

answered Dec 22, 2014 at 11:28

39 votes

Best practice between using LEFT JOIN or NOT EXISTS

answered Nov 14, 2015 at 0:27

29 votes

Why does adding a TOP 1 dramatically worsen performance?

answered Jan 29, 2016 at 2:41

27 votes

How to remove line breaks in SSMS?

answered Dec 31, 2015 at 7:53

25 votes

IF EXISTS taking longer than embedded select statement

answered Jan 14, 2016 at 14:00

20 votes

Accepted

Returning a result set with multiple rows based on max date

answered Apr 30, 2012 at 4:20

20 votes

Accepted

What's better/faster? MySql or FileSystem?

answered Aug 25, 2012 at 7:58

17 votes

Accepted

How to get exact year difference between two dates in SQL Server?

answered Jul 25, 2015 at 8:08

16 votes

Fill in missing dates with data value from previous populated date for group

answered May 17, 2016 at 4:02

13 votes

Accepted

FOR XML could not serialize the data because it contains character (0x0000)

answered Jul 16, 2015 at 18:47

13 votes

Should I use SQL JOIN or IN Clause?

answered Oct 29, 2011 at 7:40

12 votes

Accepted

sp_executesql with user defined table type not behaving correctly

answered Feb 2, 2012 at 23:19

12 votes

How (and why) does TOP impact an execution plan?

answered Sep 25, 2012 at 0:47

12 votes

A transport-level error has occurred when sending the request to the server

answered May 3, 2014 at 7:06

12 votes

Accepted

Why SELECT COUNT() query execution plan includes left joined table?

answered Oct 11, 2015 at 9:52

12 votes

Insert performance increases under load: Why?

answered Feb 22, 2016 at 10:48

12 votes

SQL SERVER Which Query is faster

answered Nov 11, 2020 at 9:08

11 votes

Accepted

Why is my plan guide not being used?

answered May 6, 2014 at 6:28

11 votes

Accepted

Correlated subquery and join: still the same exectution plan?

answered Aug 26, 2012 at 12:39

11 votes

Accepted

How do you use MAXDOP in a View?

answered Dec 5, 2011 at 13:44

10 votes

Accepted

How are indexes represented in an ERD?

answered Sep 4, 2012 at 2:48

10 votes

Execution Plan is NOT using INDEX, It uses Table Scan

answered Apr 23, 2016 at 11:27

10 votes

Accepted

Make old data read-only

answered Dec 16, 2015 at 9:03

10 votes

Odd Stream Aggregate behaviour

answered May 30, 2016 at 12:28

10 votes

Query speed optimization

answered Dec 26, 2018 at 20:49

10 votes

Accepted

Check if any of the values is in a subquery result

answered Apr 21, 2015 at 12:02

10 votes

Accepted

What would cause a table with 80,000 records to use 145GB of space?

answered Apr 26, 2020 at 11:04

10 votes

Accepted

Improving performance when ordering by a column of a joined table

answered Aug 17, 2020 at 4:12

9 votes

Why does my WHERE clause benefit from an "included" column?

answered Aug 17, 2015 at 9:27

9 votes

Why would optimiser choose Clustered Index + Sort instead of Non-Clustered Index?

answered Nov 20, 2018 at 20:21

1

2 3 4 5

…