Hi everyone, with this article we will do some Sql, T-Sql exercises. Question 1) I have a current table with date and count column. I want to get desired table as shown below picture. To clarify desired table, I want to get total counts for each mount except 2022–12–01 this date. Here…

In this article, I try to explain why Partitioned Table is soo important for performance tunning especially on the very large tables. Partitioning is a powerful feature of SQL Server that allows you to divide a large table into smaller, more manageable pieces. Partitioning can improve query performance, reduce storage…

In this article, I try to explain What is an appropriate fill factor for index and How affect query performance and fragmentation? Create 4 Tables, Indexes and set Fill Factor values This script will create 4 tables with 1 million data rows and create clustered indexes. The only different things will be fill factor rate. …

In this article, I try to add almost all usefull sql queries to get fast results. And this article will be updated time by time. Get all Tables Informations for Database To get fastly size of all tables for database. Here is the query. link Find Most Expensive Queries Find the most expensive queries for sql server. You can…

Clickhouse supports distribution and replication of data, but the documentation around it is confusing and setting up a cluster is not straight forward. I will use VMware Workstations servers(click1, click2 and click3). Operating System is Ubuntu 20.04.4 LTS (Focal Fossa) for all 3 servers(click1, click2 and click3) and Clickhouse version…

I’m posting this to hopefully help for someone else who runs across this problem.

Sometimes we need test data. So Clickhouse has built-in generateRandom() function that helps quickly generate and populate data into tables of any structure. Generates random data with given schema. Allows to populate test tables with data. Supports all data types that can be stored in table except LowCardinality and AggregateFunction. …

Hi everyone; With this article, I try to explain How we can get data from Sql Server to Clickhouse using ODBC driver. Sql Server version is Microsoft SQL Server 2019 — Enterprise Edition .Clickhouse version is 22.8.1.1440 .ODBC driver is 18 .Operating system is Ubuntu 20.04 Prepare Sql Server Side On the Sql Server…

Install Sql Server To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package. # Import the public repository GPG keys: tum@tum:~$ wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - # Register the SQL Server Ubuntu repository: tum@tum:~$ sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-preview.list)"