Jeff, thanks for the reply. We're planning to use SSIS to ETL the data, I'm just not sure I've seen any recommendations on where it should be installed. ...

I should have looked at the query plan a little closer, I didn't realize that there were heavily used cursors, which makes the stats io pretty difficult to read.

I'd certainly...

AJ, have you tried running

and then running your stored procedure a couple of times? In what object do you see the most logical reads?

Sorry about that Mani, I guess I read your post too quickly. I don't know the answer to that. SQL Server builds it's directory structure and registry entries...

Hi,

Did you read that from:

http://msdn.microsoft.com/en-us/library/bb500433.aspx ?

I don't believe that MS is saying not to use a named instance, I think they are just saying that most instance installations...

Is the SSMS you are using to connect with 2008? If so, Microsoft has said that you will not be able to connect from SSMS 2008 to SSIS 2005...

For a 100 person company, i think you're missing a zero, it'd be $16,200 for licensing CALs wouldn't it?

Are you issuing a linked server query from the old server that's causing the error message?

Are you connecting locally or from a remote machine when you use SSMS? How about when you are executing the osql command?

Hi Suresh, Do you have any full-text indexes attached to this database? It appears another member was experiencing similar issues, dropping the FT indexes and rebuilding seemed to...

Hi Jason,

Do you not have any applications that use NT authentication into the database. If not, then it's not quite as big a deal, but you probably want to...

I would certainly agree with Gail, in that you need to test these indexes/stats before implementing them blindly into your production environment. However, you may be looking at the...

There's a wealth of them out there, here are a couple of already compiled lists I found:

http://www.mssqltips.com/tip.asp?tip=1067

http://www.sql-server-performance.com/software/monitor_reviews.aspx

We personally use a mix of Quest Spotlight and in-house...

It sounds like you were trying to restore over an existing database, next time give the WITH REPLACE option a try.

restore database test from disk = 'c:\test.bak' WITH REPLACE

Also, if this is sql server 2005 or later, you might consider using the sql_modules tables instead, the old syscomments table broke the code up into multiple rows if the...