SUM & AVG Functions
https://learn.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-ver16
&
https://learn.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql?view=sql-server-ver16
Additionally,
Deep Analysis by
- WaitType Analysis
- Performance Monitor
- Index Fragmentation
- DMVs
View or change server properties
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/view-or-change-server-properties-sql-server?view=sql-server-ver16
GRANT Database Permissions
https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-database-permissions-transact-sql?view=sql-server-ver16
Installing SQL Server Native Client
https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver16
WaitTypes
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN
Internal Use only
PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN
FT_IFTS_NOISE_WORDS_RESOURCE
GDMA_GET_RESOURCE_OWNER
The solution that have fixed precision and scale is called Numeric data types
Day along with Date
https://learn.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver16
View the Dependencies of a Table
The sys.dm_tran_aborted_transactions DMV shows all aborted transactions on the SQL Server instance.
IAM and PFS Monitoring
https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-iam-page/ba-p/1637065
मेरा SQL Server, हमारा आदेश
Best Regards
T. Amit Vaid S.
Copy Databases to Other Servers
ReplyDeletehttps://learn.microsoft.com/en-us/sql/relational-databases/databases/copy-databases-to-other-servers?view=sql-server-ver16
Change the target recovery time of a database (SQL Server)
https://learn.microsoft.com/en-us/sql/relational-databases/logs/change-the-target-recovery-time-of-a-database-sql-server?view=sql-server-ver16
Netstat Usage
ReplyDeletehttps://learn.microsoft.com/en-us/windows-server/administration/windows-commands/netstat
Named Instance
https://cloud.google.com/looker/docs/best-practices/connecting-a-ms-sql-named-instance#:~:text=Microsoft%20SQL%20Server%20(MS%2DSQL,runs%20on%20its%20own%20port.
Though, I believe, there is no automated application record insertion but with SQL server it's possible.
Microsoft के सौजन्य से, अलग सोच से, आज से, अभी से हम सीखना जारी रखते हैं!
Additionally,
Data Type Float and Real
https://learn.microsoft.com/en-us/sql/t-sql/data-types/float-and-real-transact-sql
लिखा हुआ मिट जाता है ये सिर्फ गत्ता या बोर्ड कहता है! अर्थात :- अपने काम का लेखा जोखा सदियों तक संभालने की योग्यता इस technology में है!
कोई भी ढंग का article आई ए एम और पीएफएस समझा सकता है.
ReplyDeleteआपका रोज़ थोड़ा Performance पर ध्यान देना एक अच्छी environment बना सकता हैं!
Topics,
ReplyDeleteBasic Architecture, Virtual Machine, Database Encryption Keys, Joins, RTRIM, Waittype Analysis, Named Instance, Role of Timestamp column, Keys, High Availability & Native Tools.
Additionally,
ध्यान रखा? जब कोई टेबल बनानी पड़े तो पहले बंड़ा याद से उसकी परफॉर्मेंस और स्टोरेज/ग्रोथ को ध्यान में रख कर हम Indexes, Partitioning या Normalisation को भी प्लान करते हैं, ऐसे फीचर्स आदि परफॉर्मेंस में बत्ती जलाने का काम करते है, एक सोच!
Any query will be considered.
T. Amit Vaid S.