You can also (since recent SSMS) set the limit of the number of characters returned in the grid for non-XML data (varchar(max) for exemple)

The following  article is interesting : using sql server (azure sql to be precise) as a store for vectors/embeddings built with openAI and use cosine distance to compute one kind...

I tried to classified official traceflags on a dashboard where you can search on topic like "cardinality" or "index" ==> https://www.architecture-performance.fr/ap_blog/sql-server-trace-flags-classification/

Sure you're perfectly right :

CREATE OR ALTER PROCEDURE [usp_generate_view_script]
(
    @SourceSchema VARCHAR(100),
    @TargetSchema VARCHAR(100)
)

-- Usage EXEC [usp_generate_view_script] @SourceSchema='dbo', @TargetSchema='views';
AS
BEGIN
   ...

We got the answer : it was du to  the to_lower function.

Change to To_string and no collisions

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Text;

namespace DBCLRFNV1A
{
  ...

you're welcome

This query include schema :

--sqlserver 2005 +

EXECUTE master.sys.sp_MSforeachdb

'USE [?];

select getdate() as snapdate,serverproperty(''MachineName'') svr,@@servicename sv, ''?'' _dbname,SchemaName=SCHEMA_NAME(uid), TableName= object_name(p.object_id),p.partition_id,p.partition_number,

lignes = sum(

...