Useful Web Site Links for SQL Server - Prashant-kamble93/WebsiteLinks GitHub Wiki

SQL Server

SQL Server architecture :

Indexes :

Covered Indexes :

Columnstore indexes :

SQL training :

While loop :

Offset :

Stored Procedure :

How can I join on a stored procedure?

Stored Procedure Vs Function :

Stored Procedure With Real Time Scenario In SQL Server :

Functions :

Functions vs Procedure :

Transaction :

How-to-update-two-or-more-tables :

Can-we-create-two-tables-with-same-name :

SQL server :

Multiple foreign keys :

Update multiple columns :

Update multiple rows :

ex.: UPDATE membership_list SET Country = CASE ID WHEN '1' THEN 'Antarctica' WHEN '3' THEN 'Canada' END WHERE ID IN (1,3);

Insert multiple rows :

SQL Server Pivot :

Unpivot :

Real-world-examples-of-3-table-joins-in-SQL :

Pivot and Unpivot :

Use Of PIVOT in SQL Server without aggregate function(Dynamic PIVOT) :

Cursor :

Window Function :

Triggers :

Sql joins :

How join two tables using sql without common column ?

Difference between Inner join and Left join :

SQL server :

SQL server- why select is called DML? :

Ways Of Finding Foreign Key In SQL Server :

SQL server query questions :

Why cant i group by 1 when its ok to order by 1 :

Dynamic SQL server :

Split in SQL Server :

Shortcut key for SQL Server :

Lag & Lead in SQL Server :

RDBMS vs No-Sql :

RDBMS vs No-Sql vs Columnar DB :

Pages and Extents in SQL Server :

Heaps in SQL Server :

Fill factor in SQL Server :

DMV in SQL Server :

Pages in SQL Server : https://stackoverflow.com/questions/4657648/what-is-a-page-in-sql-server-and-do-i-need-to-worry

Execution sequence in SQL Server :

Indexed views :

Materialized View :

SQL Server Execution Plan :

Logical joins vs Physical joins :

Joins in SQL Server :

  1. Logical joins :

  1. Physical joins :

    1. Nested loop join :
    1. Merge join :
    1. Hash join :

Nested loop,Merge and Hash join :

Insert multiple records :

View in SQL Server :

Covering Index :

Scenario based Questions and queries :

Complex queries :

Sql server arithmetic operators :

Try-Catch :

Row_Number :

IIF Function :

Assign variable :

CTE [Common Table Expression] :

Difference between CTE and View - SQL :

Online SQL Server :

Regex in SQL Server :

Array in SQL Server :

ACID Properties :

Split Function :

SQL Server Tips and Tricks :

Employee Table Structure and Schema :

Sample Databases :

How does Google query an index of seemingly billions of web pages in a fraction of a second to produce a search result? :

Reverse String :

Types Keys :

Change Data Capture :

Store multiple values in Variable :

Convert rows into comma separated values in a column :

Converting row values in a table to a single concatenated string : *https://www.sqlmatters.com/Articles/Converting%20row%20values%20in%20a%20table%20to%20a%20single%20concatenated%20string.aspx

How Stuff and 'For Xml Path' work in Sql Server :

Merge :

Khan Academy(SQL Server Tutorial) :

Difference Between Row_Number() Rank() And Dense_Rank() :

Ranking Function:

Percentile_cont vs Percentile_disc :

SQL queries to manage hierarchical or parent-child relational rows :

Hierarchical Query using a Recursive CTE :

Create a table structure in SQL without using the create command :

Order Of Execution Of An SQL Query :

sp_who (SQL Server) :

sp_who2 (SQL Server) :

SQL Server SPID – What is it? :

Troubleshooting SQL Server Slowness :

Blocking Processes (lead blocker) :

Differences Among CTE, Derived Table, Temp Table, Sub Query And Temp Variable :

DBCC INPUTBUFFER :

Deadlock(SQL Server) :

CASE WHEN statement for ORDER BY clause :

DDL, DML, DQL, DCL, TCL(SQL Server) :

Generate XML Using FOR XML(SQL Server) :

Index Seek vs Index Scan :

Surrogate Key in SQL Server :

What is the difference between a primary key and a surrogate key? :

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions :

SQL Server Clustered Index Behavior Explained via Execution Plans :

Difference Between Union and Union All :

RAISERROR(SQL Server) :

STRING_ESCAPE :

Choose function :

SQL Server Scenarios :

Rapidly changing dimension[RDC] :

EMP and DEPT table script :

Customer table script :

Data Types(SQL Server) :

CAST() vs TRY_CAST in SQL Server :

CONVERT() vs TRY_CONVERT in SQL Server :

45 Essential SQL Interview Questions(SQL Server) :

Database Schemas(SQL Server) :

What is the importance of schema in sql server?

SQL Server Index Architecture and Design Guide :

The Search Tree (B-Tree) Makes the Index Fast :

AdventureWorks - tables information(SQL Server) :

Adventureworks Sample Database(BI/SQL Server) :

Merge Replication(SQL Server/BI) :

NEWID(SQL Server) :

Differences Among CTE, Derived Table, Temp Table, Sub Query And Temp Variable :

Generate dataset for sql server :

Surrogate Key vs Natural Key Differences and When to Use in SQL Server :

Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms :

How can I select the first day of a month in SQL :

SQL SERVER – Query to Find First and Last Day of Current Month – Date Function :

SQL Query to find the last day of the month :

Calculate fiscal year in sql select statement?

What is the difference between the IN operator and = operator in SQL?