Saturday, May 6, 2023

How to import a table from an SQL Server into another SQL Server?

The way to import a table from one SQL Server to another SQL Server is very easy.

SQL Server provides a feature to Import and Export data or complete objects to another or even the same environment. That utility is Import and Export Wizard in SQL Server Management Studio (SSMS). The Import and Export Wizard provides the facility to import or export data/objects between different data sources like flat file, SQL Server, Sybase, MySQL, Oracle, Access and Excel etc.

There are multiple ways to import or export. A few of them are given below for your knowledge. Suppose we want to import a table from one SQL Server to another SQL Server:

Step 1: Connect to the Source SQL Server Instance.

Friday, May 5, 2023

In-Place Upgrade in SQL Server

What is an In-Place upgrade in SQL Server?

In SQL Server, in-place upgrade is the way to upgrade existing SQL instances to a higher version or edition without changing the server name and hardware. 

We can perform this activity without moving the database, logins, jobs, and other objects to the new server. 

During the SQL Server in-place upgrade, the SQL server installer copies all required binaries of the new version/edition on the existing instance or setup, upgrades required binaries,  and necessary system files on the server. This activity also updates system databases as well as such as all user databases. 

The best part of SQL Server in-place upgrade is that it requires less downtime than side-by-side.

It is also cost-effective because no need to buy new hardware or licenses. 

But before implementing on the production server, implement on the test/dev environment & test properly. Check whether the application os compatible with a higher version/edition or not.


Thursday, May 4, 2023

What is Eager Writer in SQL server?

What is Eager Writer?

Microsoft SQL Server provides a mechanism to enhance write performance on a database. 

This mechanism is used to write to disk immediately or synchronously after it is changed or updated.

This feature enables faster writes to the disk which writes data pages in a more efficient manner

It does not wait for Lazy Writer to come into the picture & write the data to the disk.

The lazy writer writes dirty pages from the buffer cache to the disk asynchronously in batches.

Featured Post

Use DBCC SQLPerf (logspace)

 Use DBCC SQLPerf (logspace) to monitor and optimize database performance in SQL Server. Let's Explore: Let's Explore: https://mades...

Popular Posts