Foto%20quadrada%20per%20silvrback_large

Josep

SQL Server trace flags

Changing normal SQL Server's behavior

Introduction

Microsoft defines the trace flags as:

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior.

The purpose of trace flags is to change a SQL Server default behavior. The context they apply to can be global, session or query and it depends on the nature of the flag. For . . .

Read More

Posted in: sqlserver

March 03, 2017

SQL Server vs PostgreSQL: fighting for resources in the same server

Introduction

Notice: This is not the typical performance’s comparative between SQL Server and PostgreSQL. I only test their performance’s affectation when they run in the same server, that I would never do.

We were asked: “Is it possible to run SQL Server and a PostgreSQL in the same server?”

Obviously, the server would run under Windows. . . .

Read More

April 20, 2016

Archive