Databases

 To set max memory for Microsoft SQL server, use the below Transact SQL. USE master EXEC sp_configure ''show advanced options'', 1 RECONFIGURE WITH OVERRIDE GO --To set a maximum memory limit, type the following, pressing Enter after each line: USE master EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory> RECONFIGURE WITH OVERRIDE GO --MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate. --To hide the maximum memory setting, type the following, pressing Enter after each line: USE master EXEC sp_configure ''show advanced options'', 0 RECONFIGURE WITH OVERRIDE GO exit

Export and import records in a table using BCP To export records in a table, using below command. bcp [databaseName].dbo.tableName out <backupLocation> -n -T To import records to a table, using below command. bcp [ databaseName ].dbo. tableName IN < backupLocation> -b 5000 -h  "TABLOCK"   -m 1 -n -e <errorLogLocation> -o <outputLogLocation> -S -T