Databases

In our day to day as DBA we must create indexes to improve the performance of the queries launched against the production tables. A necessary tool would be to know what percentage of creation our index has. In many cases, we do not have an Read More

In today’s post, we will talk about the structure of the Columnstore indexes, as well as the way in which it works internally to facilitate its understanding. 1.- Columnstore. Let’s refresh the definition of column store. Column store indexes are the standard for storing and querying big sized fact tables. Read More

By Miguel Ángel Motos Posted Tuesday March 26th, 2019 In SQL Server Spanish 0 0 We are going to do a small study and comparison of the indexes oriented in columns for SQL Server (Index ColumnStore). These indexes can be up to 10 times faster than traditional indexes oriented to rows (Index Read More

In this serie of articles, we are going to talk about indexes oriented in columns for SQL Server (Column Store Index), this is an introductory post in which we will include the different aspects that we will deal with later in each of them. The Column Read More

It’s time to do more interesting things with PowerApps. In this entry, we will connect PowerApps to a SQL Server table by inserting a DataTable, because it is a good way to show data on the PowerApp. 1: Scenario. To begin, let’s create a blank PowerApp. At first, we will see Read More

Today we bring you the previous version of SQL Server 2019 CTP 2.2., so you can try it. In addition, we have provided the links so that you can download the latest updates for SQL Server 2017, SQL Server 2016 and SQL Server 2014. We remind you Read More

SQL Server Management Studio 18.0 (preview 4) is now available, and it adds support to the new SQL Server 2019 CTP 2.0 version. SSMS now requires NetFx 4.7.2 or greater: This dependency on NetFx 4.7.2, implies that SSMS 18.0 can’t be installed on Windows 8, older versions of Read More