Found it faster than I expected.

This one has a few other links on the same topic.

http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

I have noticed the...

Paul White NZ (3/19/2010)

---

It depends on exactly what you are using to connect to SQL Server.

The more you tell...

I agree with Paul. Eliminate the 5 from your FREETEXTTABLE query, and then implement the containstable.

homebrew01 (3/19/2010)

---

Ain't it though. 😀

I thought...

You say the execution plans are the same. Is that the estimated or the actual exec plans?

How many rows difference is there between the environments?

Two quick suggestions without having seen the table defs.

1. Move the derived table to a cte and perform your left outer join on that.

or

2. Change the table alias...

GSquared (3/19/2010)

---

Jason Shadonix (3/19/2010)

---

Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard...

That's awfully generous of you.:cool:

balasach82 (3/19/2010)

---

I use a Stored Procedure (with parameter) which uses 3/4 joins to retrieve some fields.i.e., a select from 3/4 tables. The problem is whenever the SP is executed for...

Nice article thanks. I like the compare and contrast between 2k5 and 2k8 that you demonstrated.

Steve Jones - Editor (3/19/2010)

---

This is a learning tool, and I could see that Microsoft bears some blame here since we try to use BOL as a reference. To that...

There are too many of those stories that are true.

One time at band camp...

Paul White NZ (3/19/2010)

---

Also:

SELECT CONVERT(INTEGER, SERVERPROPERTY('EngineEdition'));

This returns a value of 4 for Express (all variations). The 'edition' version distinguishes...

Paul White NZ (3/19/2010)

---

Me too, but it's not terribly important. There could have been another option..."it depends".

For the record, I ticked Steve,...