Monday, November 27, 2023

MS-SQL Server - A BasThar (बसठार) from विकल्प

A BasThar (बसठार) from विकल्प


We have many alternatives when it comes to SQL Server routine day to day activities.


- Basics of Recovery Model

Asymmetric Keys

- Table Variable

- Heap Tables for archived data

- Alter Statements

- Register Servers



Additionally,


- When we are unable to shrink log file we can anytime detach the database to re-create one.

- When we are unable to compress the backup as required we can strip into multiple files.

- When we are unable to shrink tempdb we can restart SQL services to re-initialize it.




/////////

TOPICS


Headeronly, Hostname and Database name,

Password policy on SSMS

Duplicate rows 

2019 SQL Server express edition

Dedicated Admin Connection


Error Message:- 18840





/////


Any query will be considered.



T. Amit Vaid S.

No comments: