MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Running Large Sized SQL Scripts in SQL Server

Hello everyone, In this article, I will try to give information about running large SQL Scripts in SQL Server. In SQL Server, in some cases, you may want to run SQL scripts that consist of too many queries, but in this case, you may also get an error. You can...

SQL Server

Cursor Changing Schema Name in SQL Server

Hello everyone, In this article, I will provide information on how to write a cursor that changes the schema name in SQL Server. While researching in SQL Server I was wondering how to change all schema names in one go. You can see the sample code for this below. Just...

Functions / SQL Server

Function to Clear Special Characters in SQL Server

Hello everyone, In this article, I will try to give information about the function that clears special characters in SQL Server. In SQL Server you may want to clear special characters in some cases. You can easily do this using the function below. CREATE FUNCTION fn_Ozel_Karakterleri_Temizle (@Temp VARCHAR(2000)) RETURNS VARCHAR(2000)...

SQL Server

Finding Unused and Missing Indexes in SQL Server

Hello everyone, In this article, I will try to give information about finding unused and missing Indexes in SQL Server. In SQL Server, in some cases, you may want to find unused and missing Indexes. You can easily do this using the code below. Finding Missing Indexes SELECT TOP 25...

SQL Server

Log File Shrinking in SQL Server

Hello everyone, In this article, I will try to give information about shrinking the log file in SQL Server. In SQL Server, in some cases you may want to shrink the log file. You can easily do this using the code below. USE DatabaseName –You will write the database name...

SQL Server

Viewing Database Restore History in SQL Server

Hello everyone, In this article, I will try to give information about viewing database restore history in SQL Server. In SQL Server, you may want to view the database restore history in some cases. You can easily do this using the code below. SELECT [restore_date] ,[destination_database_name] ,[user_name] ,[backup_set_id] ,[restore_type] ,[replace]...

Don`t copy text!