Remove c
article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

Servers 145
article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Identify Active Databases and Users in MySQL

Percona

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 100
article thumbnail

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 85
article thumbnail

Emulating the GROUPS Window Frame Option

SQL Performance

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. L0 AS ( SELECT 1 AS c. Sometimes, you need to solve a T-SQL querying task, and you know the natural tool to solve it is a feature that’s part of the SQL standard but isn’t available in T-SQL.

C++ 112
article thumbnail

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL.

article thumbnail

HammerDB v4.6 New Features Pt2: Jobs Interface

HammerDB

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB For example, we will run the following script to build a TPROC-C schema. HammerDB CLI v4.6