Concatenate string and Int in SQL server
In this article, I am going to write t-sql query to concatenate two strings and concatenate string and Int in …
SQL Server
Delete Rows from SQL Server Table
In SQL, the DELETE statement is used to remove one or more rows from a table or view. DELETE statement …
SQL Server – Could not allocate space for object in Database
I got the below SQL Database error which primarily states Could not allocate space for object in Database and suggests …
Create new SQL Database in different location using SSMS
When you create new SQL Server Database, both Primary data file and Log file of the database will be created under …
List Table Size for all Tables in SQL Database
When you feel the size of your SQL Database growing larger, you need to find the reason for what are …
FOR LOOP in SQL Server Database
I had a requirement to insert continuous numbers into continuous rows of SQL Database table for testing purpose. After gone …
Powershell script to Backup and Restore SQL Database
Getting Backup of SQL Database is important task for every DBA before making any changes in production environment, so that …
Backup and Restore SQL Database using SSMS
Getting Backup of SQL Server database is one of the very important task before doing any critical change in database …
Case Sensitive Search in SQL Query (Where)
Normally, in programming languages like C# .NET, we need to explicitly add criteria to ignore case sensitive search or compare …
Create temp table in SQL Server
SQL Server provides the feature temporary table which helps user to replace Stored Procedure that requires large number of …