SQL Server

SQL Server Topics

• Display column names separated with comma
• PIVOT and UNPIVOT in SQL Server

• how to update execution time of sql agent scheduler using sql script

• Dynamic Data masking in SQL Server

• How to insert a string value into column with an single quote (apostrophe )

• How to use Count(*) twice in one sql statement

• How to store image in SQL Server database table column

• How to Find the number of rows,allocated size, rows size, index size and free space in a table
• Sum Comma Separated values in SQL Server
• How to find underscore(_) using like operator in SQL Server
• Difference between COALESCE and ISNULL function in SQL Server

• STRING_SPLIT Function

• How to assign values to variable in sql server
• SQL Server UPDLOCK table hints
• Violation of primary key constraint
• String or binary data will be truncated

SQL Server Articles:

SQL Server Constraints

• Not Null Constraint
• Check Constraint
• Default Constraint
• Unique Constraint
• Primary Key Constraint
• Foreign Key Constraint

SQL Server isolation Level

• Read UnCommitted
• Read Committed
• Repeatable Read
• Serializable
• Snapshot

SQL Server Identity Column

• Identity Column in SQL Server

• How to find last generated identity column value in SQL Server
• Difference between IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT in sql server with example

SQL Server Functions

• REPLICATE()

• CHARINDEX()
• ISNULL()
• COALESCE()
• CONCAT()
• STUFF()

SQL JOIN

• INNER JOIN
• LEFT OUTER JOIN: 
• RIGHT OUTER JOIN: 
• FULL OUTER JOIN: 
• Self Join
• CROSS JOIN

Index

Types of Index in SQL Server

Clustered Index in SQL Server

Non-Clustered Index in SQL Server

Unique Index in SQL Server

Filtered Index in SQL Server

Full-Text Index in SQL Server

XML Index in SQL Server

Columnstore Indexes

Spatial Index in SQL Server

Hash Index (For In-Memory Tables)

Composite Index in SQL Server

Retrieve information about the database

• Retrieve information on backup and restore operations in SQL Server
• Return list of SQL Agent jobs with schedule information in SQL Server
• Count the Number of Tables in a Database in SQL Server
• Retrieve List of all Stored Procedures in SQL Server
• Display all data files for all databases with size and growth info in SQL Server
• Get all schemas, tables, columns and indexes in SQL Server
• Retrieve all Table detail from Known Column in SQL Server
• Get the list of all databases on a server in SQL Server
• Show Size of All Tables in Current Database in SQL Server

Working with Dates

• SQL Server DATEADD() function.
• Date and Time formatting using FORMAT function in SQL Server
• Date and Time formatting using CONVERT in SQL Server
• Find last day of the month using SQL Server
• SQL Server - Different types Formatting of Date/Time with Example
• Date Function : DATEFROMPARTS() and TIMEFROMPARTS()
• Date Function : DATEDIFF()
• Create function to find age as on specific date