How does your disk configuration compare to the old box (i.e. what is the allocation unit size? Was the disk aligned on both servers?, raid configs? disk speed?)?

What about the...

and still eating that...

An alternative would be to use dynamic sql to create your statements and then execute the statement that is necessary.

Another alternative would be to use an if/else statement.

Try this

declare @Color varchar(10)

Set @Color = 'yellow'

;

with redcte as (select 'red' as one,'red' as two,'red' as three from sys.tables

union all

select 'yellow' as one,'yellow' as two,'yellow' as three from...

Here are a couple of articles about indexes

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

http://www.sqlservercentral.com/articles/Indexing/68439/

And a previous SSC forum discussion on the topic

http://www.sqlservercentral.com/Forums/Topic604239-146-1.aspx

The forum discussion contains a link to a MS whitepaper on the subject.

Simply amazing how quiet the.Thread is today.

One time at band camp...

Even with a database with many tables and many columns in each table, the number of changes is limited. Even more limited when considering converting to nchar, nvarchar etc.

I...

One more reference for good measure:

http://www.mssqltips.com/tip.asp?tip=1428

As an alternative, try replacing:

...CAST(mi.sortOrder AS VARCHAR(MAX)), 1

...nh.sortOrder + '/' + CAST(mi2.sortOrder AS VARCHAR(MAX))

with

...cast(row_number() over(order by mi.parentid)...

The solution would be to change the port number for the named instance.

Microsoft explains it here.

You will only need to change the TCP port.

Understood.

Those reasons were included in my response.

1. Security Best Practice

2. It should not be an account used by anybody but the service

3. SQL services should not have...

This should work.

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Microsoft Technet statement:

http://technet.microsoft.com/en-us/library/cc966456.aspx

The account should be one to which no single person knows the entire password. The password should be lengthy. The account should only have the necessary...

Olympus

What version of SQL Server are you running?

What have you tried to resolve the issue?