सुविचार
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.
3 comments:
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
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.
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
Post a Comment