GAL0303 is absolutely right, do it the relational way instead. A search for people who speak some languages is much easier that way:

SELECT * FROM PERSON p

INNER JOIN LANGUAGE_SPOKEN ls

...

quote:

---

I seem to recall from the standard that row comparisons are done from left to right, i.e. if col_c = val_1 but...

SQL Server can't do row comparisons (that is, multiple values compared to eachother). The example Antares686 showed will probably work, but I seem to recall from the standard that row...

Is there any triggers on the table? Any other columns being updated?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Include the objectid column in the trace, it will contain the object_id of the table scanned. Then use SELECT OBJECT_NAME(123456789) to get the name of the table, where 123456789 is...

Haven't tried it yet (will do tonight), but that's what I thought as well. The total amount of memory used on the server seems to reflect this.

Chris Hedgate @ Apptus...

Wouldn't this work?

SELECT MyFunction(userid)

FROM MYTABLE

WHERE userid = some_criteria

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Thought I'd post a quick followup on this. Did the upgrade this saturday and enabled AWE memory usage, without any problems at all. Funny thing though, it seems that sqlservr.exe...

I think that depends on what OS you are running. As I've understood it, the /3GB switch is not available on Windows 2000 Server, only on NT4 Ent and Windows...

OK, great. We are running SQL 2000 Ent, so I think we're OK there , but yes, we need to upgrade to Windows 2000 Advanced Server to...

As far as I've understood, the /3GB switch is not available in Windows 2000 Server?!?

We have Windows 2000 Server and SQL 2000 Enterprise Edition, which should give us the possibility...

quote:

---

I thought I had a reference that shows where a clustered index is better than a heap in terms of performance, but...

Not sure if anyone monitors this feedback discussion any longer, but still. I am not sure as to whether I prefer case-sensitive or case-insensitive behavior on database level. I understand...

Why do you not want to use dynamic SQL? If you use sp_executesql and write it correctly your execution plans will be reused. If you use SET ROWCOUNT the optimizer...

Bringing back an old one...

Just wanted to inform you guys that I finally got around to verifying this and MS has confirmed it as a bug in SP1.

Chris Hedgate @...