Pages

▼

Monday, June 5, 2023

MS-SQL Server - सुविचार

सुविचार


SQL Server has involved so many features by reviewing other tp tools.


लेकिन तुक की बात ये है, कि बहुत बड़ी सीख मिलती है, जब हम नए जमाने के SQL Server पर काम करते हैं!


Topics to learn...

Partioning

Patching Upgrades

Multiple Rows

Management Tools


Convert MySQL to SQL

https://learn.microsoft.com/en-us/sql/ssma/mysql/converting-mysql-databases-mysqltosql?view=sql-server-ver16


Numeric Datatypes


नया Backup option अलग सोच लाया, अब third party tool के सहारे की जरूरत कम लगती है!


Optimisation Techniques

- Indexing

- Perfmon

- Waittypes


Any query will be considered.



T. Amit Vaid S.

at

3 comments:

  1. AnonymousJune 8, 2023 at 9:44 AM

    String Functions (Transact-SQL)

    The following scalar functions perform an operation on a string input value and return a string or numeric value:

    CONCAT
    CONCAT_WS
    DIFFERENCE
    QUOTENAME
    SOUNDEX
    LIKE (Transact-SQL)
    RID Lookup
    https://learn.microsoft.com/en-us/sql/relational-databases/showplan-logical-and-physical-operators-reference?view=sql-server-ver16

    ASCII
    https://learn.microsoft.com/en-us/sql/t-sql/functions/ascii-transact-sql?view=sql-server-ver16

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

    Joins Types

    - Inner join
    - Left outer join
    - Right outer join
    - Full outer join
    - Cross join

    The presence of this optimization in a given plan may not be very obvious when analyzing an execution plan, given the sort itself is a hidden operation.

    https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16

    ReplyDelete
  2. AnonymousJune 11, 2023 at 10:54 AM

    Topics
    Isolation Level, Keys & Constraints

    How to solve this error "must declare the scalar variable" even though already declare ?

    https://social.msdn.microsoft.com/Forums/en-US/236068b2-8bf3-4b1d-98f2-554fc1f8d6af/how-to-solve-this-error-quotmust-declare-the-scalar-variablequot-even-though-already-declare-?forum=aspsqlserver

    Named Instance vs Default Instance.

    नई technology पहले से अच्छि है, बाद में वाईफाई की सुविधा भी आ चुकी है, एक VPN System भी security purpose के लिए जरूरी होता है!

    Other Topics....
    Group by Clause, Numeric Datatype,
    Table Partitioning & Performance Analysis.

    ReplyDelete
  3. AnonymousJune 16, 2023 at 1:04 PM

    Breaking changes in SQL Server 2016

    Under database compatibility level 130, implicit conversions from datetime to datetime2 data types show improved accuracy by accounting for the fractional milliseconds, resulting in different converted values.

    https://learn.microsoft.com/en-us/sql/database-engine/breaking-changes-to-database-engine-features-in-sql-server-2016?view=sql-server-ver16

    Sample Database

    https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

    Unique Clustered Index
    https://learn.microsoft.com/en-us/sql/relational-databases/indexes/create-clustered-indexes?view=sql-server-ver16

    Tools
    https://learn.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver16

    INFORMATION_SCHEMA

    https://learn.microsoft.com/en-us/answers/questions/364258/how-should-i-get-a-list-of-table-names-and-field-n

    ReplyDelete