SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Practical Reporting Queries with CROSS APPLY (Part 3)

Imran2629 from SQLServerCentral

This article continues the series on APPLY, showcasing how some practical reports can be implemented using this operator.

Foreign Keys and Performance in a Microsoft Fabric Warehouse

Additional Articles from SQLServerCentral

I wanted to answer a simple question: Do relationships help, hurt, or have no effect when added to tables in a Fabric warehouse?

From the SQL Server Central Blogs - T-SQL Tuesday #202: The Two Outages I Won't Ever Forget

Jeff Taylor from Jeff Taylor

My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...

From the SQL Server Central Blogs - Advice I Like: Lots of Ideas

Steve Jones - SSC Editor from The Voice of the DBA

“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...

T-SQL Fundamentals

Site Owners from SQLServerCentral

For anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Disabled Index

I run this code on SQL Server 2022.

CREATE TABLE Drink
(
    drinkid INT NOT NULL
        CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
    drinkname VARCHAR(20),
    rating NUMERIC(2, 1)
)
GO

INSERT INTO Drink
(
    drinkid,
    drinkname,
    rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO

What is the result?

Answer: A query processor error

Explanation: When the clustered index is disabled, the query processor cannot produce a plan for the table, so an error is returned. The underlying table cannot be accessed. Ref: ALTER INDEX - https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-ver17#disable-indexes

Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2019 - Administration

How do I connect to a SQL Server database on my ISP? - I've got a web application for my side business. I've added a SQL Server 2019 database to it. Now, I'm trying to connect to it using SSMS 20.2 and also Visual Studio Code. I've been following the instructions they have here which seems straight forward to me. The error I'm getting from Visual Studio Code […]

SQL Server 2019 - Development

advice on ssrs version control - Hi we're a bit behind on versioning ssrs. I think we have over 1600 reports, 65 data sources and over 700 folders on our main sql server. And a smaller amount on a separate sql server in one of our plants. for some reason we also keep xls (over 400) , pdf's (over 3,000) […]

Editorials

The Costs of Multiple Platforms - Comments posted to this topic are about the item The Costs of Multiple Platforms

Looking for New Blood - Comments posted to this topic are about the item Looking for New Blood

The End of Summer - Comments posted to this topic are about the item The End of Summer

Measuring Productivity - Comments posted to this topic are about the item Measuring Productivity

Article Discussions by Author

Stored Procedures for Server-Level Object and Column Search - Comments posted to this topic are about the item Stored Procedures for Server-Level Object and Column Search

Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform - Comments posted to this topic are about the item Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform

RegEx Functions II - Comments posted to this topic are about the item RegEx Functions II

Adding new column with DEFAULT - Comments posted to this topic are about the item Adding new column with DEFAULT

Server-Level Row Counts for Tables and Views - Comments posted to this topic are about the item Server-Level Row Counts for Tables and Views

Hyperscale Replicas I - Comments posted to this topic are about the item Hyperscale Replicas I

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't - Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

Importing Excel files into SQL Server using DuckDB and Python - Comments posted to this topic are about the item Importing Excel files into SQL Server using DuckDB and Python

SQL Server 2022 - Administration

Performance Regression After Upgrading from SQL Server 2016 to 2022 - Bonjour à tous, La semaine dernière, nous avons effectué une mise à niveau de notre instance SQL Server, en passant de SQL Server 2016 à SQL Server 2022. Au début, tout s'est bien passé et nous avons défini le niveau de compatibilité de la base de données à 160 comme recommandé. Cependant, peu après la […]

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.