Difference between Unique Indexes and Unique Constraints in SQL Server
June 10, 2020This article gives you an overview of Unique Constraints in SQL and also the Unique SQL Server index. Along the way, we will look at the differences between them.
Search Results for: performance
An overview of computed columns in SQL Server
June 9, 2020In this article, we will explore computed columns in SQL Server and their configurations.
The basics of Parallel Execution Plans in SQL Server
June 5, 2020In this article, we will learn the basics of Parallel Execution Plans, and we will also figure out how the query optimizer decides to generate a parallel query plan for the queries.
SQL Server Choose() function introduction and examples
June 5, 2020In the article, a CASE statement in SQL, we explored one of the important logical expressions – the Case statement in SQL Server to return the values based on the specified condition. Today, we will talk about another useful logical Choose() function in SQL Server 2012 onwards and its comparison with the Case statement.
Connect Azure Databricks data to Power BI Desktop
June 1, 2020This article is next in the Azure Databricks series, where we will learn how to connect data in Azure Databricks to the Power BI Desktop. We will also talk briefly about visualizations in the Databricks service.
Impact of the Column order in SQL Server Composite Indexes
May 28, 2020In this article, we will explore the Composite Index SQL Server and the impact of key order on it. We will also view SQL Server update statistics to determine an optimized execution plan of the Compositive index.
SQL Server 2019 new features: Batch Mode on Rowstore
May 27, 2020In this article, we will explain batch mode on rowstore feature, which was announced with SQL Server 2019. The main benefit of this feature is that it improves the performance of analytical queries, and it also reduces the CPU utilization of these types of queries. Behind the scene, this performance enhancement uses the batch mode […]
How to identify and resolve SQL Server Index Fragmentation
May 27, 2020In this article, we will learn how to identify and resolve Index Fragmentation in SQL Server. Index fragmentation identification and index maintenance are important parts of the database maintenance task. Microsoft SQL Server keeps updating the index statistics with the Insert, Update or Delete activity over the table. The index fragmentation is the index performance […]
Text Mining in SQL Server
May 18, 2020In this article, we will be discussing how Text Mining can be done in SQL Server. For text mining in SQL Server, we will be using Integration Services (SSIS) and SQL Server Analysis Services (SSAS). This is the last article of the Data Mining series during which we discussed Naïve Bayes, Decision Trees, Time Series, […]
Server and Database dashboards in Azure Data Studio
May 14, 2020Azure Data Studio (ADS) is an integrated, lightweight database development for supporting both on-premises and cloud databases. It can be installed on Windows as well as Linux operating system. I am assuming you are familiar with the SQL Server Management Studio. If you work on Linux based SQL Server instance, you can install only ADS […]
SQL Server TempDB database and Latch Contention
May 13, 2020In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. We will also discuss reasons and the solution method of these latch contention issues. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019.
How to backup and restore MySQL databases using the mysqldump command
May 12, 2020In this article, I am going to explain different ways to generate the backup in the MySQL database server. As we know, data is a valuable asset to the organization. As database administrators, it is our primary and crucial job to keep the data available and safe. If the system or data center fails, database […]
Importing and Exporting data using SSIS Hadoop components
May 11, 2020In the previously published article, we talked briefly about Hadoop, and we gave an overview of the SSIS Hadoop components added in the SQL Server 2016 release, and we focused on the Hadoop connection manager and the Hadoop file system task.
Lock Configurations with SQL Bulk Insert
May 11, 2020One challenge we may face when using SQL bulk insert is whether we want to allow access during the operation or prevent access and how we coordinate this with possible following transactions. We’ll look at working with a few configurations of this tool and how we may apply them in OLAP, OLPT, and mixed environments […]
SQL Server Query Tuning tips for beginners with practical examples
May 8, 2020In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples.
Memory-Optimized Table Variables in SQL Server
May 6, 2020This article will cover the usage details and performance advantages of the memory-optimized table variables.
Build an ASP.NET app with Azure SQL Database
May 6, 2020In this article, you will learn about Azure SQL Database and its uses. Then the article splits into two sets of tutorials. The first part will show you how to create a single database in Azure SQL Database. The second tutorial will show you how to build an ASP.NET app in Azure SQL Database.
SQL Server Senior Database Administrator Interview Questions and Answers
May 5, 2020In this article, we will discuss a number of questions that you may be asked when applying to a senior SQL Server database administrator position.
SQL Server Junior Database Administrator Scenario-Related Interview Questions and Answers
May 5, 2020In this article, we will discuss a number of questions that you may be asked when applying to a junior SQL Server database administrator (DBA) position.
How to UPDATE from a SELECT statement in SQL Server
April 29, 2020In this article, we will learn different methods that are used to update the data in a table with the data of other tables. The UPDATE from SELECT query structure is the main technique for performing these updates.
View Execution Plans in Azure Data Studio
April 24, 2020This article gives an overview of viewing execution plans in the Azure Data Studio.
Getting started with SQL Server Query Tuning
April 21, 2020This article will cover some essential techniques for SQL query tuning. Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […]
An overview of ETL and ELT architecture
April 21, 2020This article explains what the basic features and differences between ETL and ELT are. I’m also going to explain in detail what an ELT pipeline is and a relevant architecture for the same in Azure. So far, we have come a long way dealing with ETL tools which basically are Extract, Transformation and Load technique […]
Importance of SQL Server Max Degree of Parallelism
April 21, 2020In this article, we will discuss how the Max Degree of Parallelism works in SQL Server and how does it improve the query performance. SQL Server Degree of Parallelism is the processor conveyance parameter for a SQL Server operation, and it chooses the maximum number of execution distribution with the parallel use of different logical […]
Learn SQL: Create a report manually using SQL queries
April 16, 2020In the previous two articles, we’ve practiced SQL queries and went through a few more examples. Today we’ll use SQL queries and create a report from scratch. We’ll start from the simplest possible query and finish with the query returning the actual report data.