MS-SQL Server - Variables, High Availability, Dashes & Retrieve Millions of Records

Variables, High Availability, Dashes & Retrieve Millions of Records

Variables

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/variables-transact-sql?view=sql-server-ver16

High Availability

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver16

Dashes

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/search/dashes-ignored-search-full-text-msidxs-queries

Retrieve Millions of Records

https://learn.microsoft.com/en-us/answers/questions/983305/how-to-retrieve-millions-of-records-quickly-from-s

Additionally,

Internal Use only,

FT_IFTS_PROJECT_FD_INFO_MAP

PREEMPTIVE_OLEDB_JOINTRANSACTION

PREEMPTIVE_OS_SETENDOFFILE

Run Stored Procedure 

https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/execute-a-stored-procedure?view=sql-server-ver16

Imp. Waittypes

PWAIT_HADR_CLUSTER_INTEGRATION

BMPALLOCATION

Any query will be considered.

T. Amit Vaid S.