sql-docs

sql-docs copied to clipboard

Update contained-availability-groups-overview.md

3

Suggestion following a CSS engagement. Customer pushed his database on contained AG which blocked his production for some time before they understood they needed to recreate the logins. Adding explicit...

ccarozzoMSFT

Update predict-transact-sql.md

4

PREDICT is off by default in Azure Synapse Analytics Add annotation The following syntax error occurs Incorrect syntax near '='. 

komorita000

New format file options

4

Added new parameter options, which are supported in SQL 2022 and included in new examples already in this document

way0utwest

Removing duplicate info box

3

Seems some merge gone wrong so the info box is displayed twice. Not sure which to keep, but "cached" sounds better in my ears

siggemannen

Fix installing-the-microsoft-odbc-driver-for-sql-server.md: key verification debian 12

3

apt changed the way it verified signature thx to Philip Z (https://learn.microsoft.com/en-us/answers/questions/1328834/debian-12-public-key-is-not-available)

S7uX

Update declare-cursor-transact-sql.md

4

Reflect that STATIC OPTIMISTIC is converted to STATIC READ_ONLY without warning.

HugoKornelis

Update sql-server-deadlocks-guide.md

4

adding information about how to handle deadlock error using try/catch block (see https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms179296(v=sql.90)?redirectedfrom=MSDN#working-with-trycatch) @microsoft-github-policy-service agree

OleksiiKovalov

Update sql-server-linux-performance-best-practices.md

6

Add a note for open file limitation. This setting do not apply to systemd services. Most Linux dist now have hard limit of nofile at least 1048576. There is no...

bangjiehan