Sunday, January 12, 2025

MS-SQL Server - Weird Circumstances

Weird Circumstances 


There are some situations when we see performance issues where it's difficult to answer, today we will discuss that....


Refer this article...

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-perf-between-servers

 

CASE


https://learn.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver16


Additionally,


ये तुम्हारी जो हमें डम्मी टेबल लगती है वो सिर्फ टेस्टिंग नहीं पर डेवलपमेंट और बैकअप के काम भी आती है!


और तुम इसके बारे में क्या जानते हो क्योंकि बेस टेराबाइट तक सीमित नहीं है!


Thanks 


T. Amit Vaid S.

बडा फैक्टर, आपको नुकसान जब मिला तो पत्तल याद आया जबकि यह सादगी भी दर्शाता है!


1 comment:

Amit Vaids Blog said...

Steps by Step Installation Guide, PWAIT_HADR_CLUSTER_INTEGRATION
https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server?view=sql-server-ver16

{How to pass an ampersand in a query string parameter? Basic hardware health report }

https://community.fabric.microsoft.com/t5/Service/How-to-pass-an-ampersand-in-a-query-string-parameter/m-p/1851872

Error Severity Event logged Descrition
4998 16 No Change tracking is not enabled on table '%.*ls'.


{Junction tables,High Character size,CLR_RWLOCK_READER}

https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/map-many-to-many-relationships-visual-database-tools?view=sql-server-ver16