Have had same problem. Workaround I use is to save the Excel file as text file and import the text file.

Here's a series of scripts I use to check who's eating up the resources. Shows IO or CPU by username, db or email domain (my usernames are email addresses)

--...

More for convenience than for speed, you might want to consider building a view based on the various table joins. Makes accessing the data easier. Also give you the option...

Maybe something along these lines.

Create Procedure testtime

as

declare @starttime smalldatetime

Select @Starttime = getdate()

waitfor delay '000:00:2' -- replace with your query

select datediff(ms,@starttime, getdate())

Store your queries results in a cursor and combine the...

Have you tried running the Stored Procedures using Query Analyser with show executing plan on. This should tell you if there is one part of the query which is eating...

Had very similar problem. We have a workflow app where tasks can have several layers of child tasks. Child rows have a reference to the parent id. Had to write...

Why have a spare disk sitting idle when you could stick it in as a mirror and deduce the risk in the first place ?

It might be worth looking at how this routine is used in the real world before coding out a load of routines which will be used 1% of the time....

Consider the impact on your transaction log if you copy to a table in the same db. It will grow with every record you add to the copy table. Copy...

We do large numbers of automated emails from our workflow application. Our scheduled DTS jobs use Javascript and XMLHTTP to call asp pages on the webserver. The ASP pages then...