Patindex, Rank, Joins and Linked Servers
Patindex
https://learn.microsoft.com/en-us/sql/t-sql/functions/patindex-transact-sql?view=sql-server-ver16
Rank
https://learn.microsoft.com/en-us/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16
Joins
https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16
Linked Server
https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16
Topics
Grant View Definition to all Users
Imp. Waittype
PWAIT_MD_LOGIN_STATS
SOSHOST_RWLOCK
SOS_MEMORY_USAGE_ADJUSTMENT
Int. Waittype
UCS_SESSION_REGISTRATION
PWAIT_HADR_FAILOVER_COMPLETED
WAIT_SCRIPTDEPLOYMENT_REQUEST
Additionally,
Scheduled Critical Change घर से नहीं करना चाहिए!
Microsoft में हर वर्ष, टीम वर्क की वजह से नई improvement मिल जाती है!
Any query will be considered.
T. Amit Vaid S.
ReplyDeleteTopics & Waittypes
Database NTLM authentication & CHECK_TABLES_INITIALIZATION
https://learn.microsoft.com/en-us/sql/connect/jdbc/using-ntlm-authentication-to-connect-to-sql-server?view=sql-server-ver16
DUMP_LOG_COORDINATOR_QUEUE, INTERNAL_TESTING, XDES_OUT_OF_ORDER_LIST, VDI_CLIENT_OTHER, XTPPROC_PARTITIONED_STACK_CREATE
Any query will be considered.
T. Amit Vaid S.
Topics and Waittypes
ReplyDeleteConfigure Max Worker Threads & GHOSTCLEANUP_UPDATE_STATS
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16
Master Database, From clause
https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16
PREEMPTIVE_COM_DELETEROWS,
COMMIT_TABLE,
PREEMPTIVE_STREAMFCB_CHECKPOINT
Topics
ReplyDeleteCheckpoint, Year Datatype, Waittype Analysis, Virtual Private Network, Partitioned Table, Scheduled Jobs
Topics
ReplyDeleteLive Query Statistics, LCK_M_BU_LOW_PRIORITY
Topics
ReplyDeleteLog Shipping, Azure, SOS_CALLBACK_REMOVAL