4 votes
Accepted

How to limit which NUMA nodes are used by SQL Server / SSRS?

I have SSRS and SQL Server running on same physical server (2 NUMA nodes). How do you configure SQL Server and SSRS to use separate NUMA nodes? You install a hypervisor, like Hyper-V, and run SQL ...
3 votes

SQL Server generating sporadic Memory Dumps

OPENQUERY & OPENROWSET functions are used quite frequently, using the latest ACE & ODBC drivers. Sorry. That's not supported, and now you know why. The Office System Drivers are only ...
3 votes

Dynamic Quorum behaviour with a witness

First, I do want to point out that there are portions of the linked article that are incorrect, however that does not change the part you've quoted which is correct. Why is this behavior by design ...
2 votes

How to limit which NUMA nodes are used by SQL Server / SSRS?

I believe you can achieve that by using the affinity option of a resource pool available on Resource Governor. See this excerpt from the Resource Pool Concepts doc: AFFINITY This setting lets you ...
  • 4,742
1 vote

How to model/query this data problem? Is this a timeseries issue?

Feature availability aside, please keep in mind SQL Server 2014 is officially no longer a supported version of the product line by Microsoft, and will stop receiving even security updates in roughly 1....
  • 26.7k
1 vote

Sql Server : How to query list of subscriptions and Articles (for a given publication) from Publisher

Regarding listing the subscribers of a publication: I had to modify the query provided by Kin Shah as sometimes I have 2 subscriptions to the same subscriber server and that query was not catching ...

Only top scored, non community-wiki answers of a minimum length are eligible