Initially, my desktop has been installed with SQL Server 2000 Standard Edition SQL Client. Recently, I installed SQL Server 2008 R2 client and server instance. I'm using SQL Server 2008 Management Studio to replace the old SQL Server 2000 Query Analyzer and Enterprise Manager. 

Yesterday I try to install SQL Server 2000 instance server but I cannot connect because when I register the server instant on Entrprise Manager I get a message that I should use the SQL Server Management Studio or SQL Server Management Objects (SMO). Where is my SQL Server 2000 instance?

Instead of using a huge IN-list, join on a VALUES expression, or if the list is large enough, use a temp table, index it, then join on it.

It'd be nice if PostgreSQL could do this internally & automatically but at this point the planner doesn't know how.

Similar topics:


https://stackoverflow.com/q/24647503/398670
https://stackoverflow.com/q/17813492/398670

