Topics
Backup, high availability and year datatypes hangs, prerequisites, keys, OLE Automation,
Document of Storage, HADR_FILESTREAM_FILE_REQUEST
QPJOB_KILL
WINFAB_REPLICA_BUILD_OPERATION
QPJOB_WAITFOR_ABORT
DISPATCHER_QUEUE_SEMAPHORE
PREEMPTIVE_COM_LBREADAT
PREEMPTIVE_HADR_LEASE_MECHANISM
Any query will be considered.
T. Amit Vaid S.
8 comments:
RAID, Scheduled jobs, triggers, year data type, Profiler, Group by, Create/Drop Index, Show Statistics, SAN, Standard Edition and Types of Hangs
Technical Documentation, Joins, Azure Managed Instance, RAISE Error, Memory, Scheduler, Analysis Services, RMO Concepts & Always On
Server Roles, high availability, Named instance
Some of the imp. waittypes.
SERVER_RECONFIGURE
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG
TRAN_MARKLATCH_EX
WAIT_XLOGREAD_SIGNAL
XTPPROC_PARTITIONED_STACK_CREATE
WINDOW_AGGREGATES_MULTIPASS
QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX
SOS_MEMORY_USAGE_ADJUSTMENT
Analysis Services, Get table definition
https://learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-table-definition?view=sql-server-ver16
Database Backup, SA Account default password.
https://learn.microsoft.com/en-us/answers/questions/602203/what-default-sa-sql-admin-user-password
Determine which version and edition of SQL Server Database Engine is running.
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/find-my-sql-version
Many Sleeping Connections & All Versions Explained
https://learn.microsoft.com/en-us/answers/questions/100075/sleeping-sessions-with-old-open-transactions-issue
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
Table Partitioning and Indexes, Pooling & Strings
https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling
https://learn.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-ver16
CheckDB Repair & System Monitor
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/performance/server-performance-and-activity-monitoring?view=sql-server-ver16
Waittypes
PREEMPTIVE_COM_LBSETSIZE
MD_LAZYCACHE_RWLOCK
PREEMPTIVE_OLEDB_RELEASE
XIO_IOSTATS_BLOBLIST_RWLOCK
Topics
- Monitoring & Threads Architecture, Logspace
Imp. Waittypes.
HADR_THROTTLE_LOG_RATE_GOVERNOR
HADR_TDS_LISTENER_SYNC_PROCESSING
AM_SCHEMAMGR_UNSHARED_CACHE
DISPATCHER_QUEUE_SEMAPHORE
FT_IFTS_DOCID_INTERFACE_LIST
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG
FCB_REPLICA_READ
Topics
Joins, Awaiting headers errors
https://learn.microsoft.com/en-us/answers/questions/1194132/how-to-handle-client-timeout-exceeded-while-awaiti
Naming conventions, Data type and maximum values
https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16
View any definition & Year and last month
https://learn.microsoft.com/en-us/sql/relational-databases/views/get-information-about-a-view?view=sql-server-ver16
https://learn.microsoft.com/en-us/answers/questions/1188651/sql-query-last-month
SQL Server 2022 Express Edition
https://www.microsoft.com/en-US/download/details.aspx?id=104781
Post a Comment