Tag: sql server
I want to output several queries in CSV format without using SQL-client or programming language, using only SQLPlus. How to do it? How do I output results to a text file using SQLPlus? I am...
Enabling profiling is an affordable way to get an accurate estimate of the time the request has been executed. First you need to enable profiling and call show profiles to get an accurate...
We will consider in detail the process of installing the free edition of MySQL 8 Community on the Windows 10 operating system. What is MySQL? MySQL is a free relational database management...
We will take a closer look at how to install PostgreSQL 11 on Windows, you will learn where to download PostgreSQL 11 for Windows, how the installation process looks like and how to connect to...
There are official ratings and other analytical data that show DBMS popularity.Some ratings are based on the frequency of reference in search engine queries, ie, if people are more often looking...
In this material I will show you how to compare two databases in Microsoft SQL Server with the possibility of further synchronization, while showing a simple way that does not require writing complex...
The Oracle/PLSQL LPAD function adds a certain set of characters from the left side of the string (at non-zero string1). Syntax of Oracle/PLSQL LPAD function LPAD( string1_id, padded_length_id,...
Sometimes you have to face the situation when in Microsoft SQL Server with the configured replication, the database distribution starts to grow. There is nothing wrong with the fact that the database...
To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps: 1. Connect to a database server using SQL Server Management Studio...
SQL Server applies role-based security rights delimitation. A role is a certain set of rights that can be assigned to a certain user or group of users.In SQL Server there are default server...
One of the tasks that one has to face during software development or DBMS administration (and, in particular, SQL Server) is determining which version of the SQL Server is installed, in which edition...
You probably already know that you can disable the index. This can be handy with large loads, and loading + enabling indexes (you will have to completely rebuild them) is faster than loading with...
When you run SELECT COUNT(*), the speed of results depends largely on the structure and settings of the database. Let's do a survey on the Votes table in the Stack Overflow database - 300 GB version...
Cool hints of requests - SQL Server documentation contains a pretty cool list of query hints: But what is the color box? Let's see.Since SQL Server query optimizer usually chooses the best...
Azure Data Studio is a free open source tool for working with Microsoft SQL Server databases. Azure Data Studio is based on Visual Studio Code and its interface is almost identical, the only...
This material provides an overview of 9 best tools that programmers and administrators use to work with Microsoft SQL Server. Azure Data Studio Azure Data Studio is a free, cross-platform, open...