At that point I decided to use DDL triggers, which unlike the DML, have not a significant impact in terms of performances. First of all we have to understand which events intercept, using this query you can have a hierarchical view of available events: WITH EventsReports (name, PARENT_TYPE, type...

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 G9 8SFF which has 2 sockets, and 12 memory banks per socket. The question I have is what would be better configuration 2 CPU's with 6 ...

The issue We have a strange issue on our mongodb setup. Sometimes we get peaks of high connections and high queues and the mongodb process stops responding if we let the queues and connections increase. We need to restart the instance using sigkill using htop. About the software environment Th...

I am using SQL Server 2012. I have a @variable that I can need to populate with data from a linked server. This @variable is then used inside a Table Valued Function. My code works as it should if I execute it actually on the linked server itself, but I really need the script to run on a dif...