as there isn't a sql 2008 performance I'm not sure if you're using sql 2008, which of course can accept batches of data as an input. If there are problems...

windows firewall ? connections don't just go away, something will have changed.

Try telnet to the sql port, then make sure the server network protocols are enabled.

I'd still suspect port...

It's always easy with hindsight - if you have builtin admins as sysadmin I doubt you'll ever find out. I usually try to remove builtin admins ( with care on...

you may be able to find this info by reading the transaction log.

data input can always be problematic, I run basic tests inserting 16kb rows and can get > 20k rows insert per second.

But you must have a good disk subsystem for...

You can in fact load balance SQL Server by using peer to peer replication; obviously you need to split/balance your queries to the multiple servers. I've evaluated it but not...

excuse the links but I wrote a serie sof posts which includes lots of info about stats

http://sqlblogcasts.com/blogs/grumpyolddba/archive/tags/Indexes/default.aspx

you need the analysing indexes posts.

Auto stats get created all the time - in...

yes they likely will be different - the optimiser was rewritten for SQL 2005.

using profiler remotely is no difference to running remote queries, both require a user connection to the database.

I'm not particularly aware that the dmvs always keep everything - certain events...

You're really only getting times from cache and for small queries it's likely to be pointless, I understand the principle but do you really expect to have multiples of exactly...

welcome to the wonderful world of query tuning! You'll have to make sure you have all the correct indexes in place with columns in the correct order - you may...

you will need an index to cover the where clause - queries against partitions can be a bit strange sometimes - I found that queries often touched each partition but...

so is this database on the same server and how quick is the original database?

too general a question!! I'd suggest you install the performance dashboard - that'll give you a nice interface to collect "bad" queries.

one way to pass hints to a view is with a plan guide - certainly you can pass a maxdop for i9nstance - if you can extract the query from...