There is no index on QuestionId in table vts_tbAnswer.

Sorry but :

CREATE CLUSTERED INDEX [idxiQuestionID] ON [dbo].[vts_tbAnswer]([QuestionId]) ON [PRIMARY]

GO

Proof your assumption wrong ...

another good one is:

Have a nice day ... unless you have other plans from "GilaMonster" 

Don't have much time now but a glance at your indexes logic indicate that your :

CREATE CLUSTERED INDEX [idxiPollID] ON [dbo].[vts_tbQuestion]([SurveyID], [ParentQuestionID], [QuestionId]) ON [PRIMARY]

GO

Should probably better be:

CREATE UNIQUE...

Here is my favorite from "rudy komacsar"

exec sp_update_resume  -- followed by

exec sp_distribute_resume

Watch out for NULLs on those <> comparisons though

what SP are you running? :

select severproperty('ProductVersion'), serverproperty('ProductLevel')

Have a look:

Monitor Database Growth on Multiple SQL Servers

Tools:

Sql Compare -> Redgate

SQL Diff --> Apex SQL (look at the add)

DB Ghost --> Look at the Adds on the site

ChangeManager --> Embarcadero Technologies

etc..

Finally there is an script that works well...

Just one more thing!

Make sure you have indexes in place for the joins and that a you are getting seeks over only one table scan!

Carlos scripting the change is maybe the only way around and is not very complicated. There is not such thing as sp_altertype

User defined data-types are not ALTERABLE!! to accomplish what you want you need to create a new type, alter those columns using the old type to use the new and...

BCP only works with csv of fixed length text files

DTS can use XL Sheets directly

Or

You can create a Linked server or use Openrowset to access the file directly from SQL

Looks very funny but is very difficult to pronounce

You just need two insert statements

insert into Table1 (fld1,fld2,fld3,fld4,fld5)

select DareID, Type, Brand, Model, Serial from XLSheet

--XLSheet is View wrapping a linked server access

insert into Table2 (fld1,fld2)

select Vendor, OuRPO...