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

...

You need to modify the code page in your query window to appropriately display the data. I'm actually not entirely sure how to do that.

We built a similar system. I outline the design and our tests in this article [/url]at Simple-Talk. To summarize, we create a version table, to which all the other tables...

Did you update all the statistics after the migration?

Generally, there are exceptions, I've found SQL Server 2005 to be a bit faster, after some adjustments. You may want to check...

You should just go through and update all the statistics, everywhere. Statistics are pretty different from 7 to 2000 and even more so from 2000 to 2005.

You'll want to...

Nothing really. The N is meant for use with string constants, the way you used it. The CAST is meant to work with just about any structural object that you...

Couldn't you ensure the distribution this way?

WHEN (DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7) BETWEEN 4 AND 8

THEN 2

And why aren't you using WEEK (or ww or...

There's no real way to know this. If the same database you have in production was on a machine, all by itself, with no users, it might take 1 minute...

jaggity (10/16/2008)

---

I might be able to use that, but my issue is that the third party defines tharray with all members as (it appears) 81 characters. So if I...