I'm sorry. The first post gave an error and I thought it had not been uploaded

I had the same problem years ago, and for it I developed a very specific application.

I have a version of the application that currently only copies tables from SQL Server...

Thank you very much for your reply.

Very interesting idea. I have turned my head, I have turned it to the left, to the right, up and down. It's good, and...

Your answer is interesting, GeorgeCopeland.

In Spain, these types of tables are called master tables.

However, I don't fully understand your idea. Just a generic table with stored procedures? And the efficiency?...

Thank you very much, ScottPletcher.

Your answer matches my assumptions.

• This reply was modified 2 years, 5 months ago by  fgrodriguez.

First of all, I would like to indicate that the previously set query had the objective of obtaining data: % fragmentation and % of used space. Its goal is not...

Obviously, it is an example of Query. Depending on the system, this query may be more or less useful.

If it is necessary to compact the lobs, the statement should be...

• This reply was modified 2 years, 9 months ago by  fgrodriguez.
• This reply was modified 2 years, 9 months ago by  fgrodriguez.

I think you have not used "sys.dm_db_index_physical_stats" correctly.

I attach a Query that could help you. Contains various flags indicating whether to rebuild indexes, reorganize indexes, or compact lobs. The limits...

Perhaps you should check the information contained in the link I send you: compacting LOBs could help you.

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-ver15#reorganize-with--lob_compaction---on--off--

Here https://sqlperformance.com/2012/07/t-sql-queries/split-strings you have a performance comparison for some methods.

As you can see, the CLR versions have no comparison with the rest. You can build them with...

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[StringToTableStrings]
(
  @cadena NVARCHAR(MAX),
  @separador NVARCHAR(MAX) = N',',
  @eliminarNulos BIT = 1,
  @trim BIT = 1
) RETURNS TABLE...

Effectively. The usefulness of this function is not that of rapid execution, but the utility of the result. That is why there is a key that lists the results and...