In my opinion, it's up to the system owner/admin to review permissions. I can help generate a list of who has access, but then its up to you to...

Get the latest backup history and generate a restore SQL script then run it on a schedule from sql agent job, eg:

DECLARE @SQLCMD nvarchar(MAX)

,@DBtoRestore nvarchar(256)

,@BackupLocation nvarchar(MAX)

,@BackupPosition...

I don't really know anyone that works nightshift as a dba. They are oncall for emergencies, but its not shift work.

Once you move into an organisation and you...

I agree with Gail, you should be backing up to a separate disk or raid group/set of spindles, disable SQL backup compression, then use Backup Exec 2012 to do data...

No, the linked report will inherit the security permissions from the master report.

If Olga is part of the AD group, then no changes are required.

Is read committed snapshot isolation enabled on one database and not the other?

SELECT name, is_read_committed_snapshot_on, snapshot_isolation_state_desc,snapshot_isolation_state FROM sys.databases

Also, when posting, please use full words rather than acronyms like "stp" (stored...

You should probably use

with the BULK INSERT statement due to having unicode data, as per http://msdn.microsoft.com/en-us/library/ms188289%28v=sql.105%29.aspx (for using different code pages)

Also the requirements for bulk inserts...

The web.config "httpRuntime executionTimeout" is only for configuring a HTTP request/session.

http://msdn.microsoft.com/en-us/library/system.web.configuration.httpruntimesection.executiontimeout%28v=vs.110%29.aspx

I can see why that would affect manual runs, however the System Report Timeout property should be causing them...

I would try doing it in a test environment.. replication may chuck a hissy if the hostname is different (even if DNS name is swapped over). There used to...

You can try change the Report Timeout under Site Settings on the report server, but you need to be a System Administrator under Security.

Also each individual report can override the...

Connect to the report server using Management Studio, (changing server type to Reporting Services). Right click properties, advanced, System Report Timeout - default is 1800 seconds.

Paul Randall has an explanation here http://www.sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield

The Waiter List is unordered (any thread on it can be signaled at any time and move to the Runnable Queue) and the Runnable...

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5bff42a4-966c-424f-8e51-67b6e17814d3/has-the-intellisense-behavior-changed-in-ssms-2012?forum=sqltools

Basically says "go to Edit->IntelliSence-> Toggle Completion Mode " however the setting is not permanent, CTRL+ALT+SPACE is the shortcut to change it.

You can also just hit tab instead.

To make it clear why the JOINs are there, you should add to the end of the example:

DELETE FROM #Source WHERE item = 'Apple'

DELETE FROM #Target WHERE item = 'Kiwi'

Then...

Do you have any SQL aliases setup on your machine?

(Run cliconfg.exe)

What happens if you directly specify the IP\instancename in your connection?

eg (172.1.1.1\myInstance)

When you connect to object explorer through SSMS,...