SET STATISTICS IO, CLR & MERGE
SET STATISTICS IO
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-statistics-io-transact-sql?view=sql-server-ver16
CLR
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/introduction-to-sql-server-clr-integration
MERGE
https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16
Additionally,
An Urgent Scenario
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eef8b2a2-2936-4ad7-b6f2-c43b33cca76a/how-to-bring-database-to-normal-from-emergency?forum=sqlgetstarted
Certification
https://learn.microsoft.com/en-us/certifications/browse/
Imp. Error Msg 682
Any query will be considered.
T. Amit Vaid S.
Merge Statement & String Functions
ReplyDeletehttps://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-ver16
Introducing data virtualization with PolyBase, SSIS, Blocked Access to cmdshell
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-ver16
Common Language Runtime
https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview?view=sql-server-ver16
Connectivity Components Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.
And
A junction table contains the primary key columns of the two tables you want to relate.
https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/map-many-to-many-relationships-visual-database-tools?view=sql-server-ver16
About Change Tracking of Database
https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16
Hyper-threaded
https://support.microsoft.com/en-us/topic/kb322385-sql-server-support-in-a-hyper-threaded-environment-a2a23c22-2400-a708-b9e3-754af6e2cd28
Move User Databases
ReplyDeletehttps://learn.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver16