Do you have traceflag 1222 enabled?

If so can you post the deadlock graph from the error log

If not run

DBCC TRACEON (1222, -1)

and then post the graphs once a deadlock has...

Yes, 2008 R2 to 2012 will work, but it can only be used for 1 way, once you make the 2012 instance active (WITH RECOVERY) you will no longer be...

SELECT

o.[name] AS ObjectName,

o.[type] AS ObjectType,

s.[name] AS SchemaName,

f.[name] AS [Filename],

i.[name] AS PrimaryKey,

i.[index_id] AS IndexID

FROM

sys.indexes i

INNER JOIN

sys.filegroups f

ON

i.data_space_id = f.data_space_id

INNER JOIN

sys.all_objects o

ON

i.[object_id] = o.[object_id]

INNER...

Unsure if you can do it in a maintenance plan, but if you can have a look at the sort in TempDB option, might not create as big of a...

You get the below error on the second backup

Msg 3023, Level 16, State 2, Line 1

Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a...

Not a problem, glad I could assist again.

What is the error message

can you zip up and attach your solution.

Have you set the connection manager of the flat file source to use an expression on the connection string of the variable?

That will ensure that the filename on the connection...

A table doesnt exist on a data file, it exists on a file group.

Are the MDF and NDF in different file groups or are they both in the primary filegroup?

Then you just need to choose your poison from one of the above methods then.

Again depends how much work and how real time you need the data to be transfered...

http://www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf

Not a book but a good poster with some of the main perfmon counters of interest.

Other things

http://www.brentozar.com/sql/sql-server-performance-tuning/

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ - Chapter 1, page 30 - 38.

http://www.simple-talk.com/books/sql-books/mastering-sql-server-profiler/

Setting a fill factor will increase the amount of space needed for the index, how much extra space depends on the fill factor being used and the index definitions.

Transaction replication would be the best one to go for, just set up the right articles to replicate.

Edit, noticed 2012 in the post, is it SQL 2000 or SQL 2012?

If...

There is no report server setting to change the parameters in SSRS from Unicode to Non-Unicode.