Do you need to hit the data live? If not, it sounds like you should use SSIS to copy the data to SQL Server on a scheduled basis.

sqlcmd does not exist prior to SQL 2005. The predecessor to sqlcmd is osql. Look this up in BOL for usage. It is still available in...

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...