WinSCP http://winscp.net

Using it via script:

https://gregcaporale.wordpress.com/2012/02/23/using-sftp-in-sql-server-ssis/

or programatically:

http://www.bidn.com/blogs/KeithHyer/bidn-blog/633/winscp-from-ssis-secure-ftp-transfers

That would not affect SSAS at all as SSAS runs independently of the SQL Server engine.

You might want to also move the SSAS databases: http://blogs.msdn.com/b/karang/archive/2010/01/19/moving-data-directory-of-analysis-services-sql-2005-2008.aspx

The log reader agent job will be running on the published db server as a SQL Agent Job. By default it is named in the format of ServerName-PublicationName-Number.

Eg....

You can update both the log reader agent job step and distrubution agent job steps by removing the "-Continuous" flag and add "-PollingInterval 86400".

86400 seconds is 24 hours.

However...

You need to attach the database with all of the checkpoint files (the files in the original mod folder). The in memory oltp tables are recreated from those checkpoint...

Yes you should try to where possible, but it is usually the DBA responsibility to either add or recommend indexes. The devs have no visibility over how the app...

The default trace has *some* auditing of login information and object creation / deletion. You could use that if you have no jobs to track usage yet.

You can also...

If you're in a bind and need some sort of info right away, you can check the default trace for growth records by date:

From https://sqlcan.wordpress.com/2012/05/14/getting-database-datalog-file-growth-from-default-trace/

DECLARE @TraceFileName NVARCHAR(512)

SELECT @TraceFileName =...

Maybe consider setting the cost threshold for parallelism higher but as long as queries arent waiting then no problem with cxpacket.

OLEDB is typical, doesnt affect the server itself much, just...

You should create a function but I just copy pasted to work out each one

DECLARE @RR nvarchar(256)

, @LowendRR nvarchar(256)

, @HighendRR nvarchar(256)

, @LowendPL nvarchar(256)

, @HighendPL nvarchar(256)

, @LowendPLvalues nvarchar(256)

, @HighendPLvalues...

High buffer I/O just means high logical IO which is probably just missing indexes or poor performing queries due to the amount of data being processed.

For example, you might have...

TomThomson (1/14/2015)

---

Andrew G (1/13/2015)

---

He has a point, the first link from the answer states:

http://msdn.microsoft.com/en-AU/library/ms189838.aspx

Valid data types for an identity column are any data types of the integer...

He has a point, the first link from the answer states:

http://msdn.microsoft.com/en-AU/library/ms189838.aspx

Valid data types for an identity column are any data types of the integer data type category,...

Try running it from DQS_MAIN

ie:

use [DQS_MAIN]

go

sp_change_users_login 'Report'

-- use UserSID from above in quer

-- Login: ##MS_dqs_service_login##

CREATE LOGIN [##MS_dqs_service_login##] WITH PASSWORD = 0x0200B94B995770F2746EB332B9A77A2728AAD0FD46D2E516015D1981C00524CAAE31CF1B8ABCD16982C3D6E566C8E1F0A5E6A1684F998C5D105ABF2D760C36CB6012EDAAEA17 HASHED

,SID = 0x5FA4E84B4F1C934096F249E32224F94A /*REPLACE THIS SID */

,...

Try run the following code on the instances with the timeout issues. You'll get a better description of the errors.

query from from http://thinknook.com/sql-server-connection-reset-for-connection-pooling-2012-02-26/%5B/url%5D

;WITH connectivity_ring_buffer as

(SELECT

record.value('(Record/@id)[1]',...