MSSQL Query Blog

9 March 2023

Fitting Unfit Codes to the Query Screen in SQL Server

Hello everyone, In this article, I will talk about how to display long query lines in SQL Server to fit the Query screen. For this process. in SQL Server Tools Options Text Editor All Languages We put a tick on Settings -> Word Wrap. When you perform the operations in...

Functions / SQL Server

8 March 2023

Function to Make Email Address Compatible in SQL Server

Hello everyone, In this article, I will try to give information about the function that makes the e-mail address compatible in SQL Server. In SQL Server, in some cases, Turkish characters may be entered in the e-mail addresses or it may be necessary to correct the e-mail addresses before entering...

SQL Server

8 March 2023

Querying Identity Columns of All Tables in SQL Server

Hello everyone, In this article, I will try to give information about querying the Identity columns of all tables in SQL Server. In SQL Server, in some cases, you may want to query the Identity columns of all tables, ie list them. You can easily do this using the code...

SQL Server

8 March 2023

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

7 March 2023

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

6 March 2023

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

5 March 2023

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

5 March 2023

Shrinking Log Files in Always On Databases in SQL Server

Hello everyone, In this article, I will try to give information about shrinking log files in databases with Always On structure in SQL Server. In SQL Server, in some cases, you may want to shrink Log files in databases with Always On structure. You can easily do this using the...