A comprehensive guide to the SQL Format function
March 11, 2020This article explains the usage of SQL Format function and performance comparison with SQL CONVERT.
Search Results for: INSERT
Database Design and Logical Asseveration for SQL Query Optimization
March 11, 2020Database design and Logical Asseveration play a vital role in database performance and SQL Query optimization. Both have different parameters to make your database and the query accurate.
How to install MySQL on Ubuntu
March 10, 2020In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
How to determine free space and file size for SQL Server databases
March 9, 2020In this article, we will discuss the actual database file size and free space in the database file size with the help of monitoring script and shrink solutions. While creating a database initial size of the database files (Data File and Log File) can be defined by us, with the Autogrowth and MAXSIZE parameter. The […]
Learn SQL: User-Defined Stored Procedures
March 5, 2020Stored procedures (SPs) are one more powerful database object we have at our disposal. They can help us handle many tasks and improve performance and security. Today, we’ll take a look at simple SPs and show, on examples, how to use them.
SQL Server Auto Shrink database property
March 5, 2020In this article, we will discuss the SQL Server Auto Shrink database property, which allows SQL Server to automatically shrink the database files when the value is configured as True in the database option. Automatic shrink operation is done by the server auto shrink database feature, which is the main course of this article.
CREATE VIEW SQL: Modifying views in SQL Server
March 5, 2020In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views. In this one, we are moving on and focusing on how to modify views. We will continue using examples on a sample database and data created in the first write-up so in order to follow along, head […]
Implementing Star Schemas in Power BI Desktop
March 4, 2020In this article, you will see how to implement a star schema in Power BI. Microsoft Power BI is a business analytics tool used to manipulate and analyze data from a variety of sources.
How to use database backups to recover data after SQL Delete and SQL Truncate statements
March 4, 2020This article explores the recovery of data removed by SQL Delete and SQL Truncate statements using SQL database backups.
SQL Server Replication Interview Questions & Answers
March 2, 2020In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.
SQL AVG() function introduction and examples
March 2, 2020In this article, we will learn the SQL Average function which is known as AVG() function in T-SQL. AVG() function is an aggregate function that calculates the average value of a numerical dataset that returns from the SELECT statement.
Learn SQL: User-Defined Functions
February 25, 2020You can create several user-defined objects in a database. One of these is definitely user-defined functions. When used as intended, they are a very powerful tool in databases. In today’s article, we’ll see how to create, change and remove them from the database, as well as how to use them. So, let’s dive into the […]
SQL CROSS JOIN with examples
February 24, 2020In this article, we will learn the SQL CROSS JOIN concept and support our learnings with straightforward examples, which are explained with illustrations.
An overview of Code Snippets in SSMS
February 24, 2020This article explores the SSMS Code Snippet feature and ways to customize it.
Learn SQL: Set Theory
February 21, 2020The set theory is very important in order to understand data and databases. While you could live without it and still be a good SQL developer, understanding it will surely help a lot. So, let’s dive into the matter.
The PARSEONLY SQL command overview and examples
February 21, 2020This article explores the uses of the SET PARSEONLY SQL command for SQL Server queries.
The internals of SQL Truncate and SQL Delete statements
February 21, 2020This article gives you an insight into the SQL Truncate and SQL Delete commands behavior.
Learn SQL: SQL Data Types
February 14, 2020What are SQL data types, why do we need them, and how to use them? Today, we’ll try to answer these questions by giving an overview of some most common data types used in SQL Server.
What is a foreign key in SQL Server
February 13, 2020In this article, we will seek an answer to an important question – “What is a foreign key in SQL Server?”. At the same time, we will give some seconder answers to this question. In this way, we can understand the foreign key concept more clearly.
A quick overview of In-Memory OLTP in SQL Server
February 12, 2020This is in continuation of the previous articles How to monitor internal data structures of SQL Server In-Memory database objects and SQL Server In-Memory database internal memory structure monitoring.
SQL AS keyword overview and examples
February 11, 2020SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.
Learn SQL: The INFORMATION_SCHEMA Database
February 7, 2020The best way how to explain what the INFORMATION_SCHEMA database is would be – “This is the database about databases. It’s used to store details of other databases on the server”. What does that mean, how we can use it, and what we can do with this data is the topic of today’s article.
Different methods to attach SQL Server MDF files
February 7, 2020This article demonstrates different methods to attach SQL Server MDF files. First, let me explain about the database files.
Importing a BACPAC file for a SQL database using SSMS
February 6, 2020This article gives you an overview of BACPAC package and its usage in SQL Database data refresh (data import and export) using SQL Server management studio.
Filtering XML Columns using XQuery in SQL Server
February 6, 2020XQuery in the SQL Server helps to query and extract data from XML documents. XQuery gives different approaches to get information from the XML document and the equivalent can be used on applying a data filter or where clause on XML elements as well.