विचार
इतनी Blocking क्यों? इस एक सवाल ने SQL Server को इतना Advance कर दिया कि मुझे गर्व हो रहा है क्योंकि सिचुएशन सही जानकारी देती है, हर लेवल पे actual infomation को देखना फिर समझना ही तो DBA की responsibility होती है, बात जब लॉक की, wait की टाइप और Deadlock तक पहुंच जाती है फिर ये प्राब्लम सिर्फ blocking clear करने के अलावा एक अलग समाधान देने की प्रेरणा देती है!!
Additionally,
Primary Keys
https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-primary-keys?view=sql-server-ver16
Principals
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/principals-database-engine?view=sql-server-ver16
Minimum Memory
https://learn.microsoft.com/en-us/answers/questions/227226/whats-the-best-practise-for-min-server-memory
Register Servers
https://learn.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-ver16
Doing Best Quality
T. Amit Vaid S.
सदा हो जय!
https://amit-sqldbasupport.blogspot.com/2023/03/ms-sql-server-worker.html?sc=1685107188703&m=1#c5759704922695658604
ReplyDeletehttps://amit-sqldbasupport.blogspot.com/2023/04/ms-sql-server-shrink-pivot-maintenance.html?m=1
ReplyDeleteTopics for today
ReplyDeleteChar varchar Datatypes
Keys and Constraints
High availablity
Express Edition
Checkpoint
Update Statistics
Backup verifyonly
Topics
ReplyDeleteCheckpoint, Unique Index, Thread ,High CPU, SSAS, SSIS
https://learn.microsoft.com/en-us/sql/relational-databases/thread-and-task-architecture-guide?view=sql-server-ver16
Architecture
Topics
ReplyDeleteNamed Instance, Unique Clustered Index and keys
Over clause
Where Clause
Having clause
Active/ Passive Cluster, Naming Standards