Well restarting the entire server seems to have done the trick...

Ok found solution to my own question, using SSIS

1 Import all relevanten Database names

select *
from $SYSTEM.DBSCHEMA_CATALOGS

2 Use a loop container to edit the connection string and replace...

Funny timing.

I am leaving my current employer after 4 years (first 4 years at work after studying).

I work/worked there as the person responisble for the ETL and the SSAS Multidimensional...

Ahoi,

for future posts:

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

for current post:

The thing ur looking for is probably Pivot/Unpivot from SQL Server, theres examples of how to use it on google

Duplicate  Post i made because i couldnt see my own post/page 2 option.

Please ignore

• This reply was modified 2 years, 6 months ago by  ktflash.

Not sure, im just using the following which was suggested earlier unless...

HMHMHMH

Job has been doing fine for the few days i used the dbo.IndexOptimize

Now the job has been stuck for 4 hours on a single index rebuild while the Job previously...

Ok i am confused, i was replacing my "alter index reorganize" part with the "execution  dbo.indexoptimize" within my script that iteratates through the for me relevant tables, job seems to...

Left a subcription

Thanks for the reply.

Weird that this is somehow not more public knowledge since the problem seems to be pretty impactful and somehow mentioned "no where" in most (popular) google results.

Not aware of that, also can't seem to find this...

select id
      ,name
      ,no
      ,sum(no) OVER(PARTITION BY id, name)
from mytable

You could check the rows that cause the conversion error.

The function returns null if the row fails to cast, so you only get the rows that fail to convert.

            
May 16, 2022 at 7:50 am
            
#4033551

            
            
                                                
        

It has been 4 years since i started this topic and joined this forum (boy time flies by in hindsight).

I told my boss i got a new job offer (after...

[/quote]

Please post the entire code for the delete loop , the CREATE TABLE statement for the table you're deleting from, and all indexes, FKs, and triggers associated with the table...