Tag Info

New answers tagged

4

Databases require certain guarantees from the storage it runs on to implement ACID. Unfortunately, it is not always possible for the database to determine if those guarantees are met. Here are some requirements that the storage (no matter if it is NAS, direct attached or SAN) must meet: Write Ordering: Writes my happen in the order they are confirmed to ...


-1

Good day to all, In my case I did an IP address change on a production server due to a migration to a better server (more memory, SSD, several cores, etc..). When the change was applied none of the users or myself were able to connect remotely; The way I fixed it was by adding an exception on the firewall for inbound/outbound connections under port 1433 and ...


7

Mark's answer cleared up a lot of my confusion, but I wanted to post my findings after I tested this using NetBalancer to emulate latency. I had my local machine call a remote SQL server and execute both SELECTs and INSERTs on a table within a small transaction. On the remote machine, I connected to the local SQL instance and used a WHILE loop to ...



Top 50 recent answers are included