MSSQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

1. About SQL Server 
• What is SQL Server
• Microsoft SQL Server Versions List
  
2. Database
• SQL Server: How to find a time when was SQL Server Restarted
• MSSQL Server : Claim DB Space After Deleting Records in Table - Reduce DB Space
  
• SQL Server OLTP vs. OLAP — What’s the Difference?
• SQL Server : Difference between OLAP and OLTP
  
• SQL Server : SQL Performance Tips and Best Practices
  
• SQL Server : ACID Properties in SQL
  
• SQL Server : SQL Server Dirty Read Concurrency Problem
  
• SQL Server : Difference Between DBMS & RDBMS
  
• SQL Server : Data Modelling: Conceptual, Logical, Physical Data Model Types
  
• SQL Server: Different States of SQL Server Database
  
• SQL Server : Star and Snowflake Schema in Data Warehouse with Examples
  
3. Basic Concepts
• SQLServer: SQL Basics
  
• SQL Server : SQL Server Data Types Tutorial
  
• SQL Server : SEQUENCE vs IDENTITY
  
• SQL Server : SQL Server Keys
  
4. Joins
• SQL Server: Never Apply INNER JOIN or EQUI JOIN on NULL Values
• SQL Server : Nested Loop vs Merge Join vs Hash Match
  
• SQL Server : Difference between table scan, index scan, and index seek in SQL Server Database
  
• SQL Server : SQL Joins
  
• SQL Server : Nested Loop, Hash and Merge Joins
  
5. Stored Procedure
• SQL Server: Introduction to Stored Procedures for SQLServer
  
• SQL Server: What is a Stored Procedure?
  
• When was Stored Procedure Last Compiled?
  
6. User-Defined Functions
• MSSQL SQL : UDF | User Defined Functions – Scalar, Table Valued (TVF), MultiStatement (MTVF)
• SQL Server : Different Types of SQL Server Functions
  
7. Triggers
• SQL Server : What are DDL, DML, DCL and TCL commands & difference b/w them?
8. Views
• MSSQL Server: Working with VIEWs in SQL Server
  
• SQL Server sp_refreshview to Update View Definition
  
9. Cursor And Loops
• SQL Server Different Types of Cursors
  
10. Index
• SQL Server : Avoid the use of Indexes on VARCHAR columns
• SQLServer: Indexes In SQL Server
  
• SQL Server:Auto Create Statistics and Auto Update Statistics
  
• SQL Server : SQL Server Index Terms
  
11. Constraints
• SQL Server: Allow Multiple NULL Values in UNIQUE Constraint
• SQL Server : Different Types of SQL Keys
• SQL Server : SQL Integrity Constraints or Constraints
  
12. Temporary Tables
• SQL Server: Difference between Temporary Table and Table Variable
• SQL Server: Difference between Temp Table and Common Table Expression (CTE)
• SQL Server : Difference between CTE and Temp Table and Table Variable
  
13. Aggregate Functions
14. Locks
• SQL Server : T-SQL script to generate a DeadLock in a Database
• SQL Server : The truth about TABLE WITH (NOLOCK)
• SQL Server : Difference between NOLOCK and READPAST table hints
• Why is the XLOCK table hint broken?
  
15. General Topic
• NULL – Typed and Non-Typed
• SQL Server: Estimated vs. Actual Execution Plans
  
• SQL Server : SQL Query Optimization
  
• SQL Server : NTEXT vs NVARCHAR(MAX)
  
• Exciting T-SQL New Features of SQL Server
  
• SQL Server : ODBC Scalar Functions (Transact-SQL)
  
• SQL Server : FOR JSON Clause in SQL Server 2016
  
• MSSQL Server : Multiple ways we can do the update statements.
  
• https://researchdatabases.blogspot.com/2021/04/sql-server-basic-performance-test.html
  
• SQL Server : SELECT all columns to be good or bad in database system
  
16. Import  (Other Source Data to SQL Server)
• Import Excel Into SQL Server
17. Interview Question & Answers
18. WebSite Links
• SQL Server Tutorial For Beginners and Professionals
  
• SQL Database Performance Tuning for Developers
  
• Powerbidocs SQL-Server-tutorials
  
• SQL Server tutorials
  
• https://docs.microsoft.com/en-us/sql/t-sql/functions/odbc-scalar-functions-transact-sql?view=sql-server-ver15
  
19. Articles
• SQL Server Maintenance Solution