Network Interfaces Error, Hangs, Write-Ahead Logging & Buffer Manager
Network Interfaces Error,
https://learn.microsoft.com/en-us/answers/questions/163193/provider-sql-network-interfaces-error-26-error-loc
FIX: SQL Server 2016 hangs when you restore
https://support.microsoft.com/en-gb/topic/kb3197605-fix-sql-server-2016-hangs-when-you-restore-databases-that-contain-memory-optimized-tables-c019ffd8-3e1e-4af8-3a7a-5a44168aa30d
https://learn.microsoft.com/en-us/answers/questions/907967/ssms-hangs-when-connecting-with-sql-login
WAL
https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-log-architecture-and-management-guide?view=sql-server-ver16
Buffer Manager
https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-buffer-manager-object?view=sql-server-ver16
Additionally,
IIS DB Manager
https://learn.microsoft.com/en-us/iis/extensions/database-manager-reference/iis-database-manager
SQL Server ने निरंतर प्रयोग, शान्ति और उम्मीद की किरन के साथ हिसाब सही रक्खा!
Any query will be considered.
T. Amit Vaid S.
Topics
ReplyDeleteOptimization's Techniques
Grant User access to Database
Surface Area Configuration
Essentials for 2019
https://learn.microsoft.com/en-us/answers/questions/893432/using-ms-sql-2019-on-windows-server-2022-essential
Linked Server
https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16
Firewall
https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16
#Range Between
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/between-transact-sql?view=sql-server-ver16
Grant Sysadmin Role
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addsrvrolemember-transact-sql?view=sql-server-ver16
Some of the imp. Topics with mix of waittypes.
ReplyDeleteGenerate GUID, String function, threads Guide, Char, Varchar, Length, Ent. & Standard Edition, Checkpoint, Set a Database to single-user mode, Left Outer join, right outer join, Capitalize/ UPPER all letters, Business Intelligence, Opposites,RTRIM() Function, Types of Locks, Build version or Patching,
VIEW SERVER PERFORMANCE STATE permission
IMPPROV_IOWAIT
PREEMPTIVE_AUDIT_ACCESS_EVENTLOG
PREEMPTIVE_AUDIT_ACCESS_SECLOG
Permissions for SQL Server 2022 and later,
Waittypes
Create Database & Backing up
PWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSS
&
RESMGR_THROTTLED
FT_IFTS_NOISE_WORDS_COLLECTION_CACHE
UCS_SESSION_REGISTRATION
BROKER_REGISTERALLENDPOINTS
ASSEMBLY_LOAD
There is a certification for DBA
Limit set for all editions
HTBUILD
PAGEIOLATCH_DT
FT_PROPERTYLIST_CACHE
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING
HADR_COMPRESSED_CACHE_SYNC
Basics, How to retrieve millions of records?
https://learn.microsoft.com/en-us/answers/questions/983305/how-to-retrieve-millions-of-records-quickly-from-s
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST
PRINT_ROLLBACK_PROGRESS
ASYNC_DISKPOOL_LOCK
BROKER_MASTERSTART
Document of Storage
https://learn.microsoft.com/en-us/sql/relational-databases/blob/compare-options-for-storing-blobs-sql-server?view=sql-server-ver16
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL
PREEMPTIVE_CLOSEBACKUPVDIDEVICE
FFT_NSO_FCB_FIND
FT_IFTS_CRAWL_BATCH_LIST
https://techcommunity.microsoft.com/t5/ask-the-directory-services-team/how-to-virtualize-active-directory-domain-controllers-part-1/ba-p/397895
ReplyDelete