Sweet! Thanks for getting involved Paul. Alright, let's take it from the top, boys! *drumroll starts*

SQLkiwi (5/23/2011)

---

Hi Craig,

It allows the Segment Top transformation without a sort, which is...

SQLRNNR (5/23/2011)

---

I haven't looked at the plans yet but something is different about them. The two show a different size. I am in the middle of reinsalling SQL...

If anyone wants an interesting optimization conundrum (at least to me), please swing by this thread I started: http://www.sqlservercentral.com/Forums/Topic1113705-392-1.aspx

I'm not a rose! I'm a free man!

Not today, no. Was time for something different, was on my mind. However the full version of it isn't professional for here....

Stefan Krzywicki (5/23/2011)

---

GilaMonster (5/23/2011)

---

LutzM (5/23/2011)

---

GilaMonster (5/23/2011)

---

Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing...

Flip the ordering, output before where. It actually goes in front of the FROM but you don't have that there.

See this for more details: http://msdn.microsoft.com/en-us/library/ms177564.aspx

GilaMonster (5/23/2011)

---

LutzM (5/23/2011)

---

GilaMonster (5/23/2011)

---

Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give...

Steve Jones - SSC Editor (5/23/2011)

---

We can debate different situations, but the way to do about this is to talk first. Talk about wanting a raise, giving reasons why you...

spx (5/23/2011)

---

@ninja, These stats are from the Actual Execution.

In the query-3, the 99% (of 104 secs) is used by the "Remote Scan/FullText Search Engine"

In the query-1, the 99% (of...

Peter Trast (5/23/2011)

---

The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:

http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx

The article by Paul has not sufficiently illuminated it for...

Couple of ideas.

Instead of a permanent table, teach them to use a #tmp and pull the data over into that. 5k rows shouldn't be that painful.

Use schema for this...

PhilDaniels (5/23/2011)

---

To my point, 2%-5% is not a raise, it isn't even a cost-of-living adjustment. Let's say you are an $80K/year employee. Your take-home is about 65% of that ($52K),...

PhilDaniels (5/23/2011)

---

I certainly agree that you try Andy's suggestions first. But also that you be (very) prepared for somebody to give you a thousand reasons why, regardless of your performance,...

Brandie Tarvin (5/23/2011)

---

GilaMonster (5/23/2011)

---

Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give...