From this query

SELECT object_name(p.object_id) as TableName,

p.partition_number as Partition

,cast( Avg( (rg.deleted_rows * 1. / rg.total_rows) * 100 ) as Decimal(5,2)) as 'Total Fragmentation (Percentage)',

sum (case rg.deleted_rows when rg.total_rows then 1...

Thank you

Thank you for your answer

Meanwhile, Suvorav, no chance you could look into the other ideas I posted - in particular the first one - isolating the SELECT queries and running them independently to see...

EMarkM (3/3/2015)

---

Ah, good old "string or binary data" - the annoying thing is that SQL must know which field and input clash caused the error, but it doesn't seem to...

yes

server is under workload

a lot of stored procedures are running

I would like to know in what SP this error exists

Maybe there are some ways to estimate how long database will be in "In Recovery" state?

I used this query for monitoring restoring process

SELECT session_id as SPID, command, a.text AS Query,...

Thank you for your answer!

I have read abour Fast Recovery here http://sqlmag.com/database-high-availability/sql-server-2012-high-availability

"

Fast recovery helps a database to be available more quickly following a restore operation. With Fast Recovery, the database is available...

The of TempDb is 7000 Mb

SELECT * FROM sys.dm_os_latch_stats where waiting_requests_count <> 0

latch_classwaiting_requests_countwait_time_msmax_wait_time_ms

ACCESS_METHODS_DATASET_PARENT250908472717032106

ACCESS_METHODS_HOBT_COUNT13618916

BUFFER278705183513078871529

BUFFER_POOL_GROW400

LOG_MANAGER21157601420

TRACE_CONTROLLER300

NESTING_TRANSACTION_READONLY16789680216

NESTING_TRANSACTION_FULL445171122431

ACCESS_METHODS_ACCESSOR_CACHE1700

The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.

That is true, log shipping from 2008 to 2000 is impossable.

I am thinking about transactional replication. What do you think about it? Is anybody using transactional replication for such...

Thanks for reply

But that is not exactly what I need.

I have performed different finctional tests and used Upgrade Advisor.

The problems will be able to ocure in the process of running...

Thanks for reply

It is additional RAID 10

Most large tables are about

15 millions rows (Data space 2 594,500 MB , Index space 709,766 MB)

5 millions rows (Data space 1 163,180 MB,...

But i think attach/ detach is better solution