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.
3 comments:
Topics
Optimization'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.
Generate 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
Post a Comment