http://sqlserverupdates.com/%5B/url%5D

What is the Windows Server Edition?

Ex. Windows Server 2003 with Service Pack 2 (SP2), Standard Edition supports a max of 32 GB of RAM

If you want to force stuff in...

This looks like a good place to start: http://www.sqlfingers.com/2014/02/total-number-of-activeopen-sql-server.html

I'm liking replication for your requirements. You could also write a custom ETL job that runs frequently.

franky.Piferoen (3/10/2016)

---

Hi,

I forgot in the previous reply to mention the error from the errorlog

Login failed for user 'SomeUser'. Reason: Could not find a login matching the name provided

Thx for the...

looks right to me.

check out the workaround in this old article:

https://support.microsoft.com/en-us/kb/925843

Run as Admin?

Remove sysadmin Server Role, use User Mapping and make the user db_owner of all databases but the one you want to exclude.

Polybase querying between Azure DW and Hadoop is cooler!

You could quickly throw your SPID into DBCC INPUTBUFFER

From PAL analysis:

SQLServer:Buffer Manager Page reads/sec

Description: SQLServer_Buffer Manager Page Reads_sec

Description: Number of physical database page reads issued per second. Number of physical database page reads issued. 80 to 90...

Are the linked server and the login/user security both setup for the same database?

Use the registered servers, and create a sub-group with only the couple of servers you want to run your query against. Right click the sub-group > new query.

I don't see in the log you posted where the system is reporting msdb as read-only, or any errors...

n.heyen (2/29/2016)

---

The development team is asking me to refresh data from Prod to Test without overwriting any stored procedures they might have on Test. So before I tell them no,...