SQL Archives - GetCodify

How to replace WordPress site URL in Database – updated 2021

February 11, 2020February 22, 2021 Arjun JSdatabase, search and replace, SQL, wordpress, wordpress URL replace0 comment

There might be many possibilities when you want to change the WordPress site URL. Completely moving your site from one domain name to another. when we want o to add HTTPS instead of HTTP which is migrating sight from HTTP to HTTPS. when you want to add www. to your site. Solution 1: Using MySQL Update replace query Solution 2: Using WordPress Plugin “Search and Replace” There are many ways we can solve this Note: Before doing any of the following methods please back up your database once Solution one…

MS SQL Server

How to Auto Restart SQL SERVER when its crashed?

December 19, 2017December 19, 2017 Arjun JSSQL, sql server, SQL server crashes0 comment

The possible reasons for SQL server crash are listed below 1 . What to do if the operating system crashed? For this, the solution is very simple. i. In PC start -> open Run, type “services.msc“. ii. In this find the SQL Services name (ex: SQL Server (MSSQLSERVER)) of the instance and then click Properties. iii. In properties window, select start type to Automatic as shown below 2. There could be situations where SQLServer is shutting down automatically due to a crash or an unexpected behaviour with SQL…

MS SQL Server

How to Fix SQL Server Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’

December 18, 2017 Arjun JSSQL, sql server, SQL server Error fix0 comment

one fine day when working with SQL server we faced this error. the error states like below ************************************************************************************************* Msg 41379, Level 16, State 0, Line 0 Restore operation failed for database ‘InMemoryDB’ due to insufficient memory in the resource pool ‘default’. Close other applications to increase the available memory, ensure that both SQL Server memory configuration and resource pool memory limits are correct and try again. See ‘http://go.microsoft.com/fwlink/?LinkID=507574’ for more information. Msg 3167, Level 16, State 1, Line 2 RESTORE could not start database ‘InMemoryDB’. Msg 3013, Level 16, State…

MS SQL Server SQL Windows Server

How to configure SQL server to access it remotely

February 7, 2017February 8, 2017 Arjun JSms sql, SQL, sql server, sql server 2012, sql server 2014, sql server 2016, sql server remote0 comment

How to configure SQL server to access it remotely?, Actually this is not a big issue there are some straightforward steps to configure, but there might be a possibility of giving problem after configure using the same steps also. So go through the below steps carefully. To establish a successful remote connection is to set up ports through the Window Firewall. In SQL Server there are two types of instances. First is a default instance and the second is a named instance. To connect to the default instance of Database…

BackEnd Programming MS SQL Server SQL

Stored Procedure Vs Function in MS SQL Server

July 20, 2016February 7, 2017 Vikram TFunctions, SQL, Stored Procedure0 comment

Stored Procedure: A set of SQL Queries which are used to perform a specific task. A stored procedure can improve the performance of a database. Function: A set of SQL Queries which can be used to pass parameters into and return values from it. Difference: Sl.No Stored Procedure Function 1 Compiled only once Complies every time the function is invoked 2 Input and Output Parameters are permitted Only input parameters are permitted 3 Need not necessarily return a value A return value is necessary 4 A Function can be invoked…