Rob Farley, Author at SQLPerformance.com

Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.

Rob Farley ◆ March 29, 2019

1

Dealing with date and time instead of datetime

Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.

Rob Farley ◆ March 29, 2018

5

Because you need to know PowerShell

Rob Farley (@rob_farley) gives a rather thorough crash course on PowerShell for this month's installment of T-SQL Tuesday.

Rob Farley ◆ September 12, 2017

8

Using AT TIME ZONE to fix an old report

Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

Rob Farley ◆ February 14, 2017

1

Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

Rob Farley ◆ January 10, 2017

2

Implementing a custom sort

Rob Farley (@rob_farley) discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.

Rob Farley ◆ October 17, 2016

9

AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.

Rob Farley ◆ July 28, 2016

34

SQL Server 2016 Temporal Table Query Plan Behaviour

For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Rob Farley ◆ June 14, 2016

0

What's "Actually" going on with that Seek?

Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.

Rob Farley ◆ June 10, 2016

12

Number of Rows Read / Actual Rows Read warnings in Plan Explorer

Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.

Rob Farley ◆ June 2, 2016

8