call microsoft.

SQL Compare by REDGATE is very useful.

http://www.red-gate.com/products/SQL_Compare/index.htm?gclid=CJmSspWWp5ICFQx7PAodrDVPRA

you can start by removing the order by clause. You can use the NOLOCK hit after the table [WITH (NOLOCK)].

But My guess since this is not a complicated query that...

you should try to enable some trace flags and see what you find at the point of failure. If that does not work you may need to run psdiag and...

is this a clustered server? Have you restarted sql server and/or the server the RAM was upgraded on?

good question: I have seen billions of rows in tables. Not sure what the maximum would be but I am guessing you would run out of disk space before you...

not certain if it will work with the application using sql server compact edition but there is a sql server 2005 compact edition. SQL Server 2008 is due to be...

fully qualifying the owner "dbo" is good practice to lower IO. The same way specifying http:// or https:// in front of a web address makes the call faster because it...

How are you viewing the data? Is there a resource problem or are you just intrested in finding out where the extra processes are coming from?

If you are just intrested...

sql server does not have a 2002 version. There is 6.5, 7.0, 8.0 (2000), and 9.0 (2005), 10.0 (2008). I am not certain what that would have to do with...

would need to know more about what the dts task is doing to answer. but books online is a great place to start.

Case does not matter when picking the server. Try it with the IP address instead of the server name to verify it works. Also As I stated before can you...

makes sense. The list is showing you what you have typed in not what is avaliable. Run CMD PING [server name], assuming the server name and the instance name are...

silly question but is the sql server service running?

two questions first.

Did you add the mssql server instance to active directory?

Does it work if you choose the other instance?