SQL Server Limitations that aren't Solved

Question

SQL Server Limitations that aren't Solved

Central data 156

I use Sql Server 2022. I'm running Select queries using hundreds of words, and I need to know, for each matching record, which words were found.

After running the Select query, I now have to run hundreds of searches for each word in each record, and it's unbelievable.

I also need Microsoft to remove the 4,000-character limit for SQL queries.

I have a document with quite a few errors that I found. I reported it to Microsoft, and they said (years ago) that they'll start working to fix it. Lie!

I'm sorry to say that Microsoft isn't improving the flaws and errors in SQL Server, which, for the most part, is the same version from the 1980s.

Isn't there any way they'll start working and fix it?

Dan Guzman 9,411 Reputation points

2025-04-24T14:37:35.0366667+00:00

I also need Microsoft to remove the 4,000-character limit for SQL queries.

The batch size limit is 268,435,456 with the default 4K batch size. How are you running the query and what is the exact error message?
Yitzhak Khabinsky 27,091 Reputation points

2025-04-24T19:49:24.1033333+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)
Central data 156 Reputation points

2025-04-24T23:14:57.4533333+00:00

Sql Server versión

Microsoft SQL Server 2022 (RTM-CU18) (KB5050771) - 16.0.4185.3 (X64) Feb 28 2025 18:24:49 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22000: )

This is the example. I omit most of the words

USE [Esp BOE - Derecho Civil]

GO

SELECT [Libro_BOE - Codigo Civil y legislacion complementaria]., FT.

FROM [Libro_BOE - Codigo Civil y legislacion complementaria] INNER JOIN

CONTAINSTABLE([Libro_BOE - Codigo Civil y legislacion complementaria], [Contenido],

'(codigo|recopilación|compilación)

AND

(casa|edificio|residencia|mansión)')

FT ON Id=FT.[Key] WHERE (ESTADO IS NULL OR ESTADO = ' ') ORDER BY RANK, Pagina, Parrafo, Linea, Palabra

The error message is: "The string beginning with '(codigo|recopilación' is too long. The maximum length is 4000".
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Yitzhak Khabinsky 27,091 Reputation points

2025-04-25T13:49:14.6433333+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)
Dan Guzman 9,411 Reputation points

2025-04-25T14:52:31.7966667+00:00

@Central data , the maximum length error message in your comment is due to the search condition parameter of CONTAINSTABLE, not the SQL query itself. You can submit a product enhancement suggestion on the feedback site to remove the restriction and upvote other requests you believe Microsoft should work on.

1 answer

Your answer

Dan Guzman 9,411 Reputation points

2025-04-24T14:37:35.0366667+00:00

I also need Microsoft to remove the 4,000-character limit for SQL queries.

The batch size limit is 268,435,456 with the default 4K batch size. How are you running the query and what is the exact error message?
Yitzhak Khabinsky 27,091 Reputation points

2025-04-24T19:49:24.1033333+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)
Central data 156 Reputation points

2025-04-24T23:14:57.4533333+00:00

Sql Server versión

Microsoft SQL Server 2022 (RTM-CU18) (KB5050771) - 16.0.4185.3 (X64) Feb 28 2025 18:24:49 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22000: )

This is the example. I omit most of the words

USE [Esp BOE - Derecho Civil]

GO

SELECT [Libro_BOE - Codigo Civil y legislacion complementaria]., FT.

FROM [Libro_BOE - Codigo Civil y legislacion complementaria] INNER JOIN

CONTAINSTABLE([Libro_BOE - Codigo Civil y legislacion complementaria], [Contenido],

'(codigo|recopilación|compilación)

AND

(casa|edificio|residencia|mansión)')

FT ON Id=FT.[Key] WHERE (ESTADO IS NULL OR ESTADO = ' ') ORDER BY RANK, Pagina, Parrafo, Linea, Palabra

The error message is: "The string beginning with '(codigo|recopilación' is too long. The maximum length is 4000".
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Yitzhak Khabinsky 27,091 Reputation points

2025-04-25T13:49:14.6433333+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)
Dan Guzman 9,411 Reputation points

2025-04-25T14:52:31.7966667+00:00

@Central data , the maximum length error message in your comment is due to the search condition parameter of CONTAINSTABLE, not the SQL query itself. You can submit a product enhancement suggestion on the feedback site to remove the restriction and upvote other requests you believe Microsoft should work on.

Answer 1

Olaf Helper 47,581

I'm sorry to say that Microsoft isn't improving the flaws and errors in SQL Serve

What for flaws and errors? I haven't got one in the past 25 years I am working with SQL Server.

I also need Microsoft to remove the 4,000-character limit for SQL queries.

If your queries are that large, then there must be something wrong with your database design and the resulting queries.

I never-ever nearly reached that limit ... in the past 25 years.

Central data 156 Reputation points

2025-04-24T23:19:08.5166667+00:00

What unbelievable explanations to cover up a situation that is obvious and verifiable!!!

I have a document with a series of serious flaws and shortcomings that cannot be resolved. I just showed two of them.

Share via

SQL Server Limitations that aren't Solved

1 answer

Your answer