Über uns

À propos de nous

Nachhaltigkeit

Durabilité

Open Access

Karriere

Carrière

Datenschutz

Protection des données

Impressum

Mentions légales

Zahlung und Lieferung

Paiement et livraison

LEXIA

LEXIA Arbeitsrecht

Was ist LEXIA?

C'est quoi LEXIA ?

LEXIA Familienrecht

Zeitschriften

Revues

recht

Pflegerecht

ZBJV

forumpoenale

ZStrR

Anwaltsrevue

Revue de l'avocat

RSAS

FamPra.ch

ASYL

Life Science Recht

BlAR

Sachbuch

Livres spécialisés

LOKI

Semaphor

Fokusthemen

Focus

Thema

Recht studieren

Arbeitsrecht

Droit du travail

Studium

Études

Familienrecht

Droit de la famille

Sozialversicherungsrecht

Droit des assurances sociales

Strafrecht

Droit pénal

Publikationen

Publications

Literatur

Onlinemodule LEXIA

Modules en ligne LEXIA

Bücher

Livres

Buchreihen

Collections

Datenbanken

recht.ch

Studienliteratur

Littérature pour les études

Services

Dienstleistungen für

Corporate Books

Publishing Lösungen

Aktuelles

Geschäftskunden

Professionnels

Corporate Publishing

Content solutions

Buchhandlungen

Librairies

Veranstaltungen

Événements

Presse

Dozierende

Enseignants

Studierende

Étudiants

Inserierende

Annonceurs

Newsletter

Blog

Autorinnen/Autoren

Auteurs

Unsere Schreibenden

Hilfe

Unsere Autorinnen und Autoren

Liste

Autorenlounge

Espace des auteurs

Bei uns publizieren

Publier chez nous

Autorenstimmen

Témoignages

Verlag

Éditions

Themen

Mehr wissen

Mitarbeitende

Collaborateurs

Geschichte

Histoire

Vision und Mission

Vision et mission

Unser Magazin

Notre magazine

Unternehmenskultur

Culture d'entreprise

Partner

Partenaires

Kontakt

Contact

Shop

Schweizer Recht

Ausländisches Recht

Über unseren Shop

Neuerscheinungen

Nouveautés

Unsere Funktionen

Nos fonctions

Vorankündigungen

À paraître

Nach Rechtsgebiet

Par domaine juridique

Kommentare

Commentaires

Gesamtkatalog

Catalogue complet

Sebastian Lohsse

Reiner Schulze

Dirk Staudenmayer

AI-Contracting

Münster Colloquia on EU Law and the Digital Economy IX

Einführung für Studium und Praxis

Europäisches Gesellschaftsrecht

A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.

The fundamentals are still here: You’ll learn how statistics and indexes impact performance, how to identify poorly performing queries, and how to discover effective solutions. But this new edition also includes advanced features unique to SQL Server 2025, such as AI integration for automatic tuning, insights on using extended events, automatic execution plan correction, and more. It’s a must-have resource designed to empower you to troubleshoot slow-performing queries and make them run faster than ever.

The book is a treasure trove of instruction, insight, and advice. As you dive in, you’ll encounter key fundamentals, from statistics and data distribution to cardinality and parameter sniffing, and learn to analyze and design your indexes and queries using best practices that prevent performance problems before they occur. You’ll also explore advanced features like Query Store for managing and controlling execution plans, automated performance tuning, and memory-optimized OLTP tables and procedures—and learn how SQL Server 2025 makes it all more powerful and automatable than ever.

What You Will Learn

Use Query Store to understand and easily change query performance

Recognize and eliminate bottlenecks leading to slow performance

Tune queries whether on-premises, in containers, or on cloud platform providers

Implement best practices in T-SQL to minimize performance risk

Design in the performance that you need through careful query and index design

Understand how built-in, automatic tuning can assist your performance enhancement efforts

Protect query performance during upgrades to the newer versions of SQL Server




Who This Book Is For

Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks—including how to identify them, understand them, and eliminate them

Troubleshoot and Optimize Query Performance

SQL Server 2025 Query Performance Tuning

Beck international

The Book
The Regulation 2017/1939 on the establishment of the European Public Prosecutor's Office (EPPO) provides the legal framework for an entirely new Union body with the power to investigate and prosecute criminal offences affecting the financial interests of the Union. The EPPO started operations on 1 June 2021 and is an additional and powerful player in criminal justice systems, working closely together with national law enforcement authorities and exercising the functions of prosecutor in the competent courts of the Member States.

The Advantages at a Glanceup-to-datecomprehensivewith practical focus
The New Edition
The second edition of this Article-by-Article Commentary guides practitioners - within EPPO as well as in the national prosecution services and law enforcement agencies, courts, and law offices - in the interpretation of the Regulation. By providing an in-depth analysis of the intricate interplay of the Regulation's provisions and their legal and practical context, it provides a valuable source for further academic research on individual aspects relating to the EPPO.

The Target Group
For practitioners - within EPPO as well as in the national prosecution services and law enforcement agencies, courts, and law offices.

Regulation (EU) 2017/1939 implementing enhanced cooperation on the establishment of the European Public Prosecutor’s Office ('the EPPO'). Article-by-Article Commentary

European Public Prosecutor’s Office. EPPO

European Contract Law

Umfangreiche Lehrplan21-konforme Sammlung von Übungsaufgaben, abgestimmt auf die gängigen Mathematiklehrmittel des Zyklus 1+2

Herbys Rechentraining rund um das kleine Einmaleins umfasst Übungen zu:

Reihen 1-10 einzeln sowie Reihen 1-10 gemischt in der Multiplikation
Von der Multiplikation zur Division
Division mit und ohne Rest
Reihen 1-10 einzeln sowie Reihen 1-10 gemischt in der Division
Kurzer Exkurs ins grosse und Zehner-Einmaleins
Repetition und Training aller vier Rechenoperationen
Fun- und Knobelaufgaben zur Auflockerung und Herausforderung

Das beliebte Rechentraining mit der bewährten digitalen Korrekturfunktion

Die Lernenden lösen abwechslungsreiche Rechenaufgaben von Hand im Heft und erhalten über die Korrektur-App PhotoCheck eine unmittelbare Rückmeldung.

Unschlagbare Vorteile von Herby:

Motivation für selbstständiges Arbeiten dank der KorrekturApp PhotoCheck
Zeitersparnis für Lehrpersonen durch automatische Korrektur
Digitale Fehleranalyse ermöglicht individuelle Unterstützung und Förderung
Herby ist über ein Smartphone oder Tablet mit Kamera für alle zugänglich

Rund um das kleine Einmaleins

Herbys Rechentraining

Jus Publicum

European integration rests on the successful application, development, and reformulation of law. This process makes it possible to overcome political resistance, stimulate European legislation, and even substitute political decisions. The circumstances surrounding its creation and changing political resistance from the Member States spoke against its success. Ferdinand Weber analyzes the origins, conditions, and development of the mechanisms that, taken together, carry a federal self-constitution inside the contractual framework. Its key lies in a specific understanding of the European treaties and its translation into methodological approaches and doctrinal constructs. At the center stands an early, jointly held-though differently articulated-constitutional imagination of key institutions and actors which lead to a material hierarchization of the treaty objectives in relation to other norms of the European treaties. Methodologically, this constitutional imagination translated into a claim to effectiveness that distinguishes Union law from international law: the specific 
 effet utile
 of Union law, which has achieved the status of a guiding norm. It stands at the top of the derivational framework of subsequent Union law doctrines, which, after gaining autonomy as principles or norms in their own right, detach themselves from their reference to it. The author explores the origins and further development of this process through an analysis of the 
 effet utile
 , the protection of fundamental rights, European citizenship, and the values of the Union, before considering offers of legitimacy and the European Court of Justice as an "alternative judiciary."

Zu Grund und Methode rechtlicher Ordnungsbildung im europäischen Integrationsprozess

Föderale Selbstverfassung

Was bedeutet es, Mensch oder Maschine zu sein? Was als militärisches Projekt beginnt, entwickelt sich zu einem ethischen Dilemma und einer ernsten Bedrohung für die Gesellschaft: Die Quantenphysikerin Elsa Quinlan erschafft ELIAS, die erste KI, die lernt, denkt und fühlt. Da taucht mit LILITH eine weitere KI auf, die ihre eigenen und unberechenbaren Pläne verfolgt. Wem kann Elsa jetzt noch trauen? Und welche Folgen hat dieser wissenschaftliche Triumph für die Menschheit?

Elias

GELBE SERIE - leicht gemacht

This book provides a quick and concise overview of European Union law in all its facets. Practice-oriented and pedagogically sound, it covers all relevant topics: - History of the EU from a legal perspective - Types of European law - Institutions, including the European Court of Justice - The European Single Market, including EU fundamental freedoms, state aid, and competition law

Europarecht - leicht gemacht

Warum wir ein deutliches Mehr an Innovationen benötigen

Der Kampf um unsere Wettbewerbs- und Zukunftsfähigkeit

The question of what purposes companies should serve is crucial within company law doctrine and jurisprudence. Legislators in various jurisdictions are increasingly questioning shareholder primacy and considering the interests of stakeholders such as employees, creditors, and consumers, as well as environmental protection. This book explores these developments and moves beyond the dichotomy of the shareholder and stakeholder models. As limiting the discussion to these two variants is misleading from the perspective of corporate sustainability, the book seeks to re-evaluate the concept of the company's interest in light of the current ecological, social, and economic challenges arising under the umbrella of sustainability.

With contributions by
Tonio Friedmann, LL.M. | Prof. Dr. Géraldine Goffeaux Callebaut | Morton Gullhagen-Revling | Dr. Ieva Kozlovska | Dr. Diletta Lenzi | Prof. Dr. Lela Mélon | Prof. Dr. Lina Mikaloniene | Prof. Dr. Anne-Christin Mittwoch | Prof. Dr. Andreas Rühmkorf, LL.M. | Dr. Dr. Christoph Schmetterer | Prof. Dr. Beate Kristine Sjåfjell, LL.M. | Aleksandra Szcz¿sna | Dr. Anne-Marie Weber, LL.M.

This title is also available as Open Access.

AI-Contracting

Autres titres sur ce thème