If it's doing a seek operation, but it's still slow, I'm inclined to look at index fragementation or out of date statistics. You do have automatic update of statistics enabled,...

I've been working on the whole concept of unit testing TSQL for quite a while. At this point, I'm a bit more in Phil's camp. We do "unit testing" as...

danschl (10/17/2008)

---

FAST number_rows

Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows are returned, the query continues execution...

Still, that's information. I'll set up a test database over the weekend and try a couple of things.

I have to wonder why on earth it would matter...

Interesting.

What query or queries did you run against it to get a recommendation?

I can't imagine that the database would matter, but the one I'm using is the 2008 version of...

Execution plan?

It will treat them, as much as it can, as a whole. But the more complicated the query, the longer it will take the optimizer to find a good plan....

I'm sorry, no, I can't.

The basic structures look a lot like what you see in the article.

I've got another article coming out in the SQL Standard this month that compares...

What do the indexes on these tables look like? For example, because of this statement:

AND ap.ProcedureID <> ap1.ProcedureID

If ProcedureID is the leading edge of the index used in the...

That really sounds almost identical to the system we did with history & inprocess tables. While we migrated between the two, the structures and queries were pretty much as I...

You're referring to the same table twice for some reason. This should be enough

SELECT FIRST_NAME, USER_ID

FROM EMPLOYEE

LEFT OUTER JOIN USER_PGM_AUTHORITY ON EMPLOYEE.FIRST_NAME = USER_PGM_AUTHORITY.USER_ID

WHERE FIRST_NAME = USER_ID

The listing of...

Oops. Missed that entirely. Thanks Matt.

The second versioned system we created had an Inprocess and a History storage. The Inprocess was a multi-day or even multi-week approval process. Once approved, the new version and the...

The areas I've been looking at are:

http://msdn.microsoft.com/en-us/library/ms144250(SQL.90).aspx

and

http://msdn.microsoft.com/en-us/library/ms180175(SQL.90).aspx

I'm just not sure how this translates the data on the screen.

I tried this, but it didn't work:

select N'????????' COLLATE Chinese_PRC_BIN as china

...

The areas I've been looking at are:

http://msdn.microsoft.com/en-us/library/ms144250(SQL.90).aspx

and

http://msdn.microsoft.com/en-us/library/ms180175(SQL.90).aspx

I'm just not sure how this translates the data on the screen.

I tried this, but it didn't work:

select N'????????' COLLATE Chinese_PRC_BIN as china

...