5
votes
Accepted
Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?
The given schedule S is:
T1 T2
---- -----
R(X)
W(X)
W(X)
To be view serializable W2(X) must move before R1(X) or after W1(X). However, the first would violate the "initial read" rule and ...
- 25.1k
4
votes
Accepted
Where is the documentation for version 1.0 of PostgreSQL wire protocol
It is all in the Git repository, here is a link to the source. You can actually read the SGML source pretty well.
- 56.5k
4
votes
Accepted
Connecting to a remote SQL named instance with named pipe
Although the named instance TCP port 50002 was blocked, port 445 is used for named pipes (SMB) and is apparently allowed by the firewall.
The SqlClient driver tries TCP/IP first and then falls back ...
- 28.5k
3
votes
Accepted
Why can I use named pipes to connect to SQL Server even if it's been disabled?
Check the SQL Server error log for the named pipes provider messages. With named pipes enabled, you should see messages like those below and be able to connect both locally and remotely over named ...
- 28.5k
3
votes
Accepted
Does SQL Server require NetBIOS for Named Pipes?
Yes
From this MSDN forum discussion, Tibor says:
Named Pipes uses NetBIOS
And from this MSDN forum discussion, Puzzle_Chen says:
Named pipes use the NetBIOS session layer
- 2,018
2
votes
Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?
I don't find it clear to ask if Thomas write rule "allows" view serializable schedules. Proper question should be,"whether the schedule "generated" by thomas write rule is ...
- 21
2
votes
Accepted
Cannot connect to SQL server through SSMS from other machine after IP change
Possible Solutions
Did you restart the SQL Server instance after the IP address was changed? If not, then the SQL Server was possibly still listening on the old IP address.
When connecting locally ...
- 18.3k
2
votes
Accepted
MySQL Transport Protocol Used
There are two passive ways to find that out
Connection Status
MySQL Prompt
EXAMPLE
If you execute the status command (\s)
mysql> \s
you get this output
MySQL://localhost/root/mysqld.sock/(none)&...
- 184k
1
vote
Connection string for a successful SSMS connection
SSMS (SQL Server Management Studio) does not directly reveal the exact connection string it uses in its UI. However, you can recreate the connection string by first following these steps to ensure ...
- 384
1
vote
Where is the documentation for version 1.0 of PostgreSQL wire protocol
You can refer to the manual of older Postgres versions.
Postgres 7.3 is the latest version using frontend/backend protocol version 2.0:
This document describes version 2.0 of the protocol, ...
- 182k
Only top scored, non community-wiki answers of a minimum length are eligible