Rob Farley

less info
meta site favicon meta user | stack exchange network profile network profile
2,656 reputation
1311
bio website lobsterpot.com.au
location Adelaide, Australia
age 38
visits member for 1 year, 7 months
seen May 19 at 22:12
stats profile views 84

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)


66 Answers

newest activity votes
12
Should I use SQL JOIN or IN Clause?
9
Correlated subquery and join: still the same exectution plan?
8
How do you use MAXDOP in a View?
7
What's better/faster? MySql or FileSystem?
7
Over use of Oracle With Clause?
7
Extra tables are added when I create a new Database
6
Why would a SELECT INTO cause an arithmetic overflow?
6
SQL Server 2008: use AVG() and an inner join
6
How to disable case sensitivity in SQL Server 2005 for object name (Table name)?
6
Is shrinking a transaction log OK to do on a live database?
6
Returning a result set with multiple rows based on max date
5
Are these two queries technically equal to each other?
5
Why isn't the transaction log getting truncated when taking a full backup?
5
How are indexes represented in an ERD?
5
Performance tuning for gap analysis of table
5
PLS FIND OUT THESE INTERVIEW QUESTIONS I HAVE FACED THESE QUESTIONS(PLS HELP ME PLS…)
4
Alternative query to this (avoid DISTINCT)
4
query optimization delete nested query
4
Shrink database is not shrinking as much as expected on a 1.5 TB database.
4
Benefits of using backtick (`) in MySQL queries?
4
SQL Server: Look for column headers
4
Using 100's of schemas in a database SQL2008R2?
4
sp_executesql with user defined table type not behaving correctly
4
Determining that Indexes on a table are unused
4
Run several commands against data in text file (SQL Server 2008 R2)
3
does a subquery pull the entire table?
3
How (and why) does TOP impact an execution plan?
3
How to know what to investigate and how for a VERY slow stored procedure
3
Schema for 1 <-> 0..1(+), many related but only one primary
3
Calculate MSB on MySQL
1 2 3