Tag: Microsoft SQL Server
Today I want to talk about the simple things that will help novice SQL programmers more correctly, thoughtfully and simply make the logic of their queries and learn SQL faster.All of these...
Every self-respecting web developer should know SQL.Although it has existed since the 70s of last century, it is still very widely used, and without it it will be difficult to create...
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...
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...
SQL - in simple words, it is a programming language for structured queries (Structured Query Language), which is used as an effective way to save data, find its parts, update, extract from the...
SQL ALTER TABLE statement is used to add, modify or delete columns in a table. ALTER TABLE SQL statement is also used to rename a table. Add a column to a table SQL syntax of ALTER TABLE...
SQL UNION statement is used to combine the resulting sets of 2 or more SELECT operators. It removes repetitive strings between different SELECT requests.Each SELECT statement in UNION must...