WLHG Operator / Clauses and Waittypes, Schedules, String functions, Virtual Machine.
- WHERE
- LIKE
- Having
- Group by
Additionally,
Particular Msg 8510, Level 20, State 3, Line Number
Enlist operation failed:
https://support.microsoft.com/en-us/topic/kb4052119-fix-new-distributed-transactions-in-an-ag-database-fails-after-you-restart-dtc-service-in-sql-server-2016-af73cc09-a629-d4a4-bfd1-36a0278b89b9
Other Imp. things to learn
1. SUM, AVG
2. ROW_NUMBER
3. Stored Procedures
4. Views
5. Functions
https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16
Select - Window Clause, Joins, ETL Package, DBA query
https://learn.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-package?view=sql-server-ver16
7.3 KB = ? Bytes
5.3 MB = ? KB
3.3 GB = ? MB
Builds & Azure SQL's Zone redundancy
---------------------------------------------------
//////////////////////////////////////////////////////////////
Topics
WLHG Operator / Clauses and Failover Cluster, SMALLINT, Reporting Services, Int, Bigint, Cast and Convert, Trigger, Backup Compression, Restore Verifyonly.
- WHERE
- LIKE
- Having
- Group by
Seems like 9 year ofs Support and so many year ofs remembrance of every single feature with additional Waittype feature and Range between by clause is most common.
[KE] Unique Keys
One Star Achievement we already have now.
• * Performance Improvement Techniques have been deeply enhanced and segregated. High Availability monitoring is furthermore improved. Inbuilt automated Features for Developers can be used along with Prod Environment eg. CDC. Alert Notifications have reduced the burden to some extent.
• * Learn
• * Learn
//////////////
Topics
Duplicate rows
SQL Server 2019
https://www.microsoft.com/en-in/sql-server/sql-server-2019
Subscription Reinitialization
Error 2297
///////////////
Any query will be considered.
T. Amit Vaid S.
3 comments:
Topics
Types of Database Migration
Types of client connections to replicas
Types of functions
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/about-client-connection-access-to-availability-replicas-sql-server?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver16
Topic
Bigint Convert, Virtual Private Network, DDL vs DML commands.
error code: 112
https://learn.microsoft.com/en-us/answers/questions/967543/sccm-back-up-failing-(error-code-112-error-message
Imp. Waittypes
REMOTE_DATA_ARCHIVE_SCHEMA_DMV, PWAIT_XTP_FSSTORAGE_MAINTENANCE & FT_IFTS_RWLOCK
Post a Comment