MS-SQL Server - Rename Object & Understanding WKT (Well Known Text)

Rename Object & Understanding WKT (Well Known Text)

Here we will learn on how to Rename any type of Object

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-ver16

Well known Text

https://learn.microsoft.com/en-us/bingmaps/v8-web-control/map-control-concepts/well-known-text-examples/

Additionally,

Imp. Wait Types

MISCELLANEOUS

AUDIT_XE_SESSION_MGR

AUDIT_GROUPCACHE_LOCK

AUDIT_LOGINCACHE_LOCK

AUDIT_ON_DEMAND_TARGET_LOCK

///////////////////////////////////////////////////////////////////////////////////////

How to create SQL Active Active Instance

https://learn.microsoft.com/en-us/answers/questions/427708/how-to-create-sql-active-active-instance

High Availability and Disaster Recovery for Master Data Services

https://learn.microsoft.com/en-us/sql/master-data-services/installing-mds-in-an-alwayson-group-environment/installing-mds-in-an-alwayson-group-environment?view=sql-server-ver16

Installation Tutorial

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server?view=sql-server-ver16

SQL Server: How to determine parameter sniffing problem and how to handle it

https://learn.microsoft.com/en-us/answers/questions/262485/sql-server-how-to-determine-parameter-sniffing-pro

Median PERCENTILE_CONT

https://learn.microsoft.com/en-us/sql/t-sql/functions/percentile-cont-transact-sql?view=sql-server-ver16

Remove Scientific notation in measure

https://community.fabric.microsoft.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/761639#M367041

Other Imp. Waittypes

BROKER_TRANSMISSION_TABLE

DISPATCHER_PRIORITY_QUEUE_SEMAPHORE

PREEMPTIVE_SP_SERVER_DIAGNOSTICS

SEQUENTIAL_GUID

Any query will be considered

T. Amit Vaid S.