Ah, I thought you were getting the memory error while trying to move the database.  Now it makes more sense.  Look at your Max Server Memory setting.  You have it...

From BOL: "

Note  Do not change the packet size unless you are certain that it will improve performance. For most applications, the default packet size is best."

I do not think that...

Leave your GUID column as the unique primary key, but create it non-clustered.  Then, create a descending clustered index on your int column. 

It doesn't appear that your cursor does much more than loop through your table and give you the last ID number.  I did not take a very long look at...

Have you tried rewriting the select with a join? 

select col11,col12,col13=' ',col14

into dbo.table1     

from  remoteserver.database.dbo.table2

 INNER JOIN table1

 ON table2.col15 >= table1.col21

WHERE table1.col22 = 101

How long does it take to run the SELECT col21 FROM table1 WHERE col22 = 101 statement?  Is col22 indexed?

You can split the data out using filegroups.  I think you have to drop and recreate the tables you want to move.  EM allows you to do this, but I...

Schedule a second interview and make it a 'team' interview.  Let your team interview him/her and just sit back and watch how the prospect interacts with the group.  Make the...

You can combine your select statements into one result set using UNION.  Look it up in BOL.  You may also consider using a group by to get your totals.  For...

I agree, great use of numbers table.  I have seen this concept explained before, but never put to use and because of that, I have not tried to use it...

'How do you know that person is right for the job?'

Simple, you set your expectations in your job requirements.  If you want to hire a DBA or developer, you must...

Pam is on the right track.  You will have to loop through the string, but it doesn't have to be 'hairy'

CREATE FUNCTION ExtractNumbers ( @String varchar(4000))

 RETURNS varchar(4000)

AS

BEGIN

 DECLARE @ReturnString varchar(4000),

  @SubString char(1),

  @index...

This function accepts a character string and, based off of the delimiter that you pass in, it will split the string down into its individual parts.  Those parts are then...

Both the log shipping and BCP solutions will require some setup and testing.  Read through BOL and see which method fits your needs.  If you have specific questions as to...

Just curious, what will you be using this table for?  It seems like you are introducing an awful lot of overhead here.  How many users does this system have? ...