Use display execution plans to check for

1) table scans -- which means missing index, bad sql join, or bad where clause criteria.

2) index scans -- it's using an index, but...

http://msdn.microsoft.com/en-US/library/ms189858(v=sql.105).aspx

See link. It's an either by partition or all.

First step should always be to use explain plan to look for table scans, among other things. That would usually indicate a missing index, a bad join, etc...

You've can...

What is your code page in SSIS flat file connector?

What is your database collation?

I just imported from a csv file the below data into test1 table with fields id int...

convert(datetime,convert(char,getdate(),102))

The inner convert removes the time portion. The outer convert brings it back to date

You completed with:

At this point, all passive nodes has the service pack installed and it’s time to perform the update on the active node (serverA), so connect to it and...

In order to query two databases, you set up a linked server under 'server objects'

The code is below:

/****** Object: LinkedServer [MyDB\MyInstance] Script Date: 11/11/2011 09:07:21 ******/

EXEC...

You can start by 1) adding this to your company table

alter table company

add [account number] as left(companyname,6)

2) Then create the index for it.

3) Change your sql to use...

I have the same problem, but my @@servername is set.

Any other ideas?