Pages

▼

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.

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


at

1 comment:

  1. अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} BlogJanuary 21, 2025 at 7:50 AM

    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

    ReplyDelete