Also, if copying via explorer, pull it from the QA server rather than push from the prod server.

do it by backup\restore. No down time required as its an online operation, I have never seen a backup cause a noticeable performance issue, especially if you route the...

you can only have one instance of SSIS per machine, so whether that wide a range of versions would work happily I'm not sure.

There were no more queries. Those...

is it me or is steve moonlighting? 🙂

http://www.youtube.com/watch?v=DYvbMaCXXxc

Also, adding a clustered index will allow you to defragment the leaf level of the clustered index, i.e. the data pages themselves. That could save a shed load of space.

Are you saying you only have 4 single column non_clustered indexes that add up to 103GB? How many columns in the table?

A clustered index is always a good thing to...

3 easy points blown.

must.read.question.carefully.

add column [rs].[user_name] to the select list

if you have no access to this server a restore of the msdb on your server as a user database would give you the information you need, no other information...

please read these

http://www.sqlservercentral.com/articles/Administration/64582/

http://msdn.microsoft.com/en-us/library/ms189493(v=sql.100).aspx

the same as for any other database. The only effect replication has is that the transactions will have to have been replicated before you can shrink past the virtual log...

As far as SSRS goes, copying is the same as moving. You will need to configure SSRS in your QA environment, including setting up the RS databases. MAKE SURE you...

if you usee the one from BOL (and it works well enough) be sure to insert code into it so that it updates statistics on...

then I would say that database was just busier than the others in terms of throughput. Was a reindex running at the time perhaps?

There are limits to how many databases...