This often happens when one query plan doesn't convince SQL Server to use parallel...

Have you tried turning those row_number sub-queries into aggregates? I've tried both, and sometime the aggregates are faster.

Something like this:

;with

-- Publication Version CTE, used for Pub CTE

PubVersion (DocID,...

DBA (5/21/2008)

---

SELECT len as Length, p.productnumber,p.productID_PK AS ID

FROM Products P

WHERE p.Active = '0'

(p.productname)...

Jack: Yeah, I saw your posts, and didn't want to be redundant on that point. I totally agree with you, just wanted to add a couple of possibly pertinent...

Another solution to this is don't bother updating the base table, just use Row_Number() in the queries if you want to show that sequence.

If you do it the other way,...

When you say that the syntax you've come up with isn't working, what exactly do you mean? Do you get a syntax error on it? Does it not...

The quick answer is update the table using RTrim.

update dbo.Table

set Column = rtrim(Column)

Since you're using Varchar data type, that will probably do it.

If it doesn't, the thing to do is...

Keep in mind that an inline function (like these) has an overhead to it. With something as simple as the dateadd version for this, you're better off including it...

Matt Miller (5/21/2008)

---

GSquared (5/21/2008)

---

The reason for this is that, in a Left Outer Join, any criteria on the left table need to be in the Join clause, or they make...

Steve Jones - Editor (5/20/2008)

---

I'm always amazed how many people are weeded out from a simple test/quiz beforehand. At one point I made sure that I only interviewed people that...

pduplessis (5/21/2008)

---

GSquared meant to put @table...

Syntax:

declare @table table(identifier int identity(1,1), ModuleID tinyint)

insert into @table (ModuleID) values(1)

insert into @table (ModuleID) values(2)

insert into @table (ModuleID) values(3)

declare @counter tinyint, @ModuleID tinyint, @string varchar(max),...

On the syntax error, I can't duplicate it. I tested the code, and it compiled and ran just fine. Did you copy-and-paste the code from this forum into...

These two:

Need to be in the Join criteria, not in Where clause. I'm not sure...

That one, per what I've read, is fast to query, but slow to update/insert/delete. Adjacency hierarchies...

I've used hierarchies with as many as 7,000 nodes and as many as 50 levels. CTEs work well for those.

But one thing that should be brought up in any...