Get the list of temporal tables in SQL Server DB
Using simple sql technique, here we will see how to get the list of temporal tables in a database.
SQL
Check and drop system-versioned temporal table if exists
How to check and drop a system-versioned temporal table if it exists in the database as temporal tables are different from regular tables?
How to find the history table of a temporal table?
Here a simple trick to find the name of the history table of a system versioned temporal table using SQL select statement.
Find if system versioned temporal table exists
Let us see how to check if a specific table is system versioned temporal or not using SQL script. SQL tips to check if temporal table exists.
Creating and using temporal table (system-versioned table) in SQL Server.
Temporal table otherwise called as system-versioned table helps you to maintain the version history of the data in the table in a automated way.
Get only the common records from two tables using INTERSECT
With example how to get only the common records from two tables using INTERSECT and the advantages of INTERSECT over INNER JOIN.
Get records from one table which are not present in another table using EXCEPT
Getting records from one table which are not present in another table using EXCEPT operator in SQL Server.
Concatenate columns to string in SQL Server
In SQL Server there are several ways to concatenate columns to a single string. Here are few methods for concatenating columns based on the version of SQL Server.
Formatting SQL statements in SSMS
Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.
How To Get The Week Number Of Year In SQL Server?
Here is the simple tip to get the week number of the year In SQL Server using an in-built function.
How To Get Name of Month In SQL Server?
Quick tip for getting the name of month In SQL Server for a specific date or current date.
IIF vs CASE in SQL Server
Let us see the major differences between IIF vs CASE. IIF is a logical function and CASE is a language expression.
Collecting Poor Performing Queries And Storing Them For Analysis (Using Extended Events)
Simple step by step illustration for collecting poor performing queries or batches and store them for further analysis in SQL Server using Extended Events.
Collect Poor Performing Queries And Store Them (Using Profiler)
How to collect poor performing queries or batches and store them in a database table for further analysis in SQL Server using MSSQL Profiler?
Is It Good To Use VARCHAR(MAX) Instead Of VARCHAR(N)?
Is it a good practice to use VARCHAR(MAX) instead of VARCHAR(N)? We will see the answer and the reason for it in this article.
VARCHAR(MAX) vs VARCHAR(N)
VARCHAR(MAX) vs VARCHAR(N). Comparing the differences, advantages and disadvantages between VARCHAR(MAX) and VARCHAR(N).
Extract Numbers From String In SQL Server
How to extract only the numbers from string value In SQL Server? Here is a function which extract the sets of numbers from alpha numeric strings.
SELECT vs SET: Which Is Better In SQL Server?
Which Is Better SET or SELECT? In this article you will see the major differences of SELECT vs SET and the comparison between them in table from.
Reduce Index Fragmentation
Here is the T-SQL queries to reduce index fragmentation by using either INDEX REORGANIZE or INDEX REBUILD. You will also see when to REORGANIZE and REBUILD.
How To Find Index Fragmentation
Here is the T-SQL query to find index fragmentation in SQL Server database. This query will list all the indexes in the database and the the fragmentation level in percent.