Friday, July 21, 2023

MS-SQL Server - Benefits of Unique and Non Clustered Index?

Benefits of Unique and Non Clustered Index?


An article as Questionnare...


2. Maintenance Plan Covers how many things?


3. Name any one easy function for Numeric datatype calculation?


4. How many types of High Availability that has no extra Hardware requirements?


5. What are the year data types?


6. What is the best way to capture performance counter data for Maintenance?


Additionally,

Imp. Waittypes

AUDIT_ON_DEMAND_TARGET_LOCK

BACKUPTHREAD

PREEMPTIVE_AUDIT_ACCESS_EVENTLOG

PAGEIOLATCH_SH



Error 9959





Any query will be considered.



T. Amit Vaid S.

1 comment:

Anonymous said...

Bug Fix KB4548597
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate4

Status 112
https://support.microsoft.com/en-gb/topic/error-message-112-setup-is-unable-to-decompress-and-copy-all-the-program-files-c8dadf2a-4e7e-11bf-6543-ab5560b7fc19

Additionally,
Headeronly option of Database backup is very useful.

SQL Server एक महान कार्य लगता है!