I did a quick test kind of following Gregory's suggestion except I did not use profiler I user Set Statistics Time On. The first thing I did was create...

Drew (3/10/2008)

---

Thank you for the quick reply, I don't think I was specific enough with my question however.

Let's assume that those queries are not contained in a stored procedure and...

Good article with a clear, concise explanation and test.

If you are linking to another SQL Server why are you using ODBC? You can directly link by name or use SQLOLEDB which both remove the overhead of ODBC....

When I say run the single inserts once is, instead of running this stored procedure with the cursor and and dynamic sql, run it once to create the insert...

How many "companies" do you need to create? Will they increment by 10?

You could do this in single SQL Statement:

While @num <= [target]

Begin

Insert Into table

...

By having varying column names you have a difficult task. I think ksullivan's reply will work, but it does not sound very scalable. Does your "dynamic" sp have...

Can you manually run a backup against that database using:

backup database db_name to ...

If you can do that can you successfully execute that command in a SQL Server Agent Job?

It...

Are you using char(nchar) or varchar(nvarchar) because, especially when using fixed length fields SQL Server has to expand the rows which is probably going to cause page splits and, if...

Correct, Full Text Search searches within a SQL Server database, not documents outside it. That is what Google Desktop, Windows Desktop Search are for.

1. Compile the data to show that there is a problem with disk access.

2. How much memory is on the server? What is the Buffer Cache Hit...

The Top 10 is limiting the rows being returned across the pipe, but is still causing the Source server to do a table scan or index scan as you are...

Have you considered using an Execute SQL Task within a For Loop container? You can create a variable that contains you sqlcommand and change that each time through the...

Since an Access DB was not really designed to be concurrent user you may gain some benefit by upsizing to SQL Server. You can test it first. The...

First, are you including all the tables in your database in the IN list? If you are you should get rid of the IN and use where TABLE_CATALOG =...