Its working with this way, takes 42 seconds to import 27.000 entities

DECLARE @X XML

SELECT @X = CAST(x AS XML)

FROM OPENROWSET(

BULK 'C:\temp\teste.xml',

...

Hi,

to the first question, it takes 2 seconds.

To the other question, I'm testing, and return sooner with the answer

i'm testing with this code:

DECLARE @X XML

SELECT @X = CAST(x AS XML)

FROM...

Just solved with this way, dont know if very good way, but its working

SELECT CONVERT(INT, dbo.OSUSR_BZA_USER_LOGIN_DAY.UserProfilePercentage) AS PERCENTE,

...

yes it have a primary key